Hello everyone, I am rather new to VBA programming and would like a little advice.

I am recording/writing a macro to do some data transformation, sorting, and formatting on a report that I run monthly. On columns where I have a formula being copied down for all rows where there is data, how can I make this function not a set range (i.e A1:A5335) but one that will continue to copy down until it gets to the last row with data in it?

The reason is that about every 3 months new rows are added and I really do not want to have to remember to go in and change the range.

Any help would be great and if you would like some clarification on what I need just let me know.