Problem with Macro Only Running one cell at a time

[boogyman00123]

Hello,

I am new to the whole MACRO VBA thing and I am desperately trying to learn. So this is the Situation. I recorded a macro of an If statement on a row. very simple. Some of the rows below ( Like 700) need the same formula that I recorded. I would like to highlight the cells that need the formula and run the macro on them. however the macro only runs one at a time. Is there a way that this can be avoided?

Thank you so much in advance,

J

[Richard Buttrey]

Hi,

How about filtering the column or columns so that only the rows you want to see are visible, then enter the formula in the first cell and copy it down the rest of the visible cells. Then remove the filter.

I'd avoid any sort of looping macro that moves from cell to cell since loops are generally quite slow and usually filtering data is the easiest way to do this sort of stuff.

[Solus Rankin]

Please Login or Register  to view this content.

[jolivanes]

Please Login or Register  to view this content.

Is this what you mean?
Adjust the references to what you need.
HTH
John

[boogyman00123]

Thank you Richard,

I have tried that. It just takes time. I want to get to a point where the whole thing is automated. This is what I have.

In Sheet 1 I have a CODE column. down the column there are about 50 different Codes. Each code has a Corresponding If formula. I wrote that formula on the column next to it.

In Sheet 2 I have several column with Numerical numbers. One of those Columns however has the Corresponding Code to a part number (the same code in Sheet 1). Is there a way to do something like a Vlookup so that I could Match the two codes and have it spit out the not the value but the formula on sheet 2?

Let me know what you think.

and thanks again

[boogyman00123]

THAT IS PERFECT! thank you! that works for my temporary problem. If you look at the post below you will see what the goal is. THANK YOU SO MUCH FOR THIS THO! It is incredible!

[Richard Buttrey]

Thank you Richard,

I have tried that. It just takes time. I want to get to a point where the whole thing is automated. This is what I have.

Hi, perhaps I should have been more explicit. I didn't expect you to do it manually, I had rather assumed you would write a filter macro to do it automatically.

[jolivanes]

Criteria to filter on is in cell D1.
Change formula to what you need.
Change references to suit.
Assumes that you want to filter on column A

Please Login or Register  to view this content.

[boogyman00123]

So I have another question. Im sorry guys im just new. I appreciate the patience.

So lets say that I create the Macros. For the all type of formulas. Is there something, like a vlookup for macros. As if to search for something and used the assigned Macro?

[jolivanes]

"For the all type of formulas"

How many different formulae are you talking about?
What are the different formulae?
In Post#8, the value of cell D1 is a variable used for AutuFilter.
Maybe you could attach a file with the before and after.

[boogyman00123]

Macro Help.xlsx

well the formulae are if statements that I have created in macros. they basically add or multiply different numbers found in the same sheet. the formulae work. so do the macros. I just have to filterthe data, then run the macro for that code and repeat. There are 57 different codes I have to do this for. I just want to automate it or write something that will read the code and run the appropriate macro on the cell.

here is the macro that im running now:

Please Login or Register  to view this content.

[jolivanes]

Could attach a workbook with has at least all the values for you macros (that is at leat 28).
I assume that all the macro names, CERT, CSTK, EEBT, EEPR, EEPT, ENAV, EOTH and so on are the values,
or text if you wish, in Column C.
Where do you select for the macro that has "no activity" in the formula and where does this "no activity" come from?

Maybe make a new attachment with all possibilities because now it is only guessing (for me anyway) or
explain step by step what you do, where you select and what the criteria are. Then the next step.

I am sure you know what you're after but without proper explanation, I don't.