Different range of cells to clear

[miles44]

I have a data table A1:R70.

Each day it will have a different amount of data in it.

For instance, the first day only A1:R41 will be filled. The next day, only A1:R60 and so on.

What I want to do is for each day, have a macro that will clear out the data in the empty cells below the filled cells.

So on the first day, A42:R70 will be cleared. The second day A61:R70 will be cleared.

I know how to select a static range by "Range(A1:R70).Select".

What do I use in the macro for this changing range?

[maniacb]

I recommend you first find the last row +1 and then use a line to clear the remaining.

Please Login or Register  to view this content.

[miles44]

That did it!