Macro €“ select all cells in current range
I have a file which has a summary sheet and a daily sheet. At the end of
each day I want to copy the data from the daily sheet to the summary sheet
and use a macro to do this.
My problem is that each day the number of rows I need to copy will vary.
The columns will remain the same.
Is there a way to instruct the macro to select all the cells in the current
range and for that to have a varying number of rows?
If I can do this by recording the action it would be easier for me.
|