Basically I have Titles in Row 1 and formulas in row 2. A:3 through Apick a number) has data in it. I then use the fill down function to fill the formulas from B:2 C:2 E:2 and so on. I generally fill down by double clicking the fill square and it automatically fills as far down as the column beside it. I then created a macro to do this for me, how do I get the macro to fill down only as far as the column beside it?
Here is what I have so far which would be fine if the amount of rows in column A never changed.
I tried adding the IF ISBLANK into every formula and then making my range to B:9000 or something but a couple of my formulas are kissing the character limit and I can't get around it. I know I could just make another cell somewhere with some values and use references but my sheet is already very large and I need to keep it clutter free
Code:
Range("B2").Select
Selection.AutoFill Destination:=Range("B2:B18")
I tried adding the IF ISBLANK into every formula and then making my range to B:9000 or something but a couple of my formulas are kissing the character limit and I can't get around it. I know I could just make another cell somewhere with some values and use references but my sheet is already very large and I need to keep it clutter free