Is there a way to fill column "B" down to the very last cell located in column "A" when column a varies each time? Thanks for any help.
I'm trying to get it to work and I kind'a get what's happening, but I'm trying to get a formula to copy downward and I'm just not grasping the concept. This is the formula I'm working with:
Please Help. Thanks again
Now then Foxxy,
There are always different ways around any problem. However, for autofilling formula downwards I normally use this solution.
''Calculate the end cell of column ACode
a = Range("A65536").End(xlUp).Row Range("B2").Select ActiveCell.FormulaR1C1 = "Type in your recorded macro formula" Range("B2").Select Selection.autofill Destination:=Range("B2:B" & a)
If you are using a lookup function, perhaps after the formula, when all the rows had calculated, then you should copy and paste special the values - just an idea if you are dealing with lots of data.
Foxxy1, BeginnerBob, I just added code tags to your last posts.
Cardinal rule of the forum, guys, please be mindful.
Don’t have an account yet? Register yourself now and be a part of our community!