G
Guest
I have formulas that i need to copy to fill the end of each of a set of data
ranges. The data is all in A1 to A500, with the ranges seperated by empty
rows. The ranges are of variable length. The formula is required in the A
column just where the blanks appear in the ranges.
Why can't I record a relative address macro that incorporates variable
ranges? I use the end-down-down keys when recording the macro.
Do I have to use a VBA script for something this simple?
ranges. The data is all in A1 to A500, with the ranges seperated by empty
rows. The ranges are of variable length. The formula is required in the A
column just where the blanks appear in the ranges.
Why can't I record a relative address macro that incorporates variable
ranges? I use the end-down-down keys when recording the macro.
Do I have to use a VBA script for something this simple?