Loop add formula

[Jietoh]

Hello All!

I'm working on a worksheet activate triggered macro that will followin the below steps.
1: Find the next blank cell in Column "BB"
2: check if there is anything in the cell next to it in column "BA"
3a: No - exit
3b: Yes - copy the formula in the cell above (in column "BB") and paste it in the cell found in step 1
4: Loop for as long as there is data in column "BA"

Here is what I have so far, but obviously its not working.

Please Login or Register  to view this content.

Thanks in advance.

[JBeaucaire]

Perhaps this is the wrong solution to the wrong problem. So, people are adding values in column BA and you need the BB formula to be added automatically? My solution would be to make sure that formula is being added at the moment they enter those BA values.


What is the formula in BA2?

[Jietoh]

JBeaucaire: BA is in fact a formula -

Please Login or Register  to view this content.

However, BA is the last column in a table, so when new line is added to the table the formula autogenerates. I don't want column BB to be apart of the tablefor a number of reasons, thus why I went with the above attempt.

[JBeaucaire]

Staying with worksheet_activate, then, all at once:

Please Login or Register  to view this content.

Or is there a different formula to add in BB?

[Jietoh]

Perfect! I tweaked it slightly, but this is exactly what I needed.