Select a dynamic range

Greetings, Gurus.

This will be an easy on for you seasoned programmers. I want to find the last used cell in a column, and then select an offset range based on the location of that cell.

For example, in the attached workbook, I have a button at the top that activates a macro to add a new week to my time sheet. This simply copies the contents of the current week, and adds it at the bottom.

What I would like to do next is clear the data from the newly added cells, leaving the formulas in columns A, B, C, J and K.

In the attached example, I have just added Week 3. I would now want to locate the last used cell in Column C, (C24), then offset from that cell to select the range D18:I24, and clear the contents of those cells.

Thanks in advance for any help you can offer.

To make your initial code flexible as well try:

Please Login or Register  to view this content.

hth
Rob

Thanks for the feedback - I'm pleased we could help :-)

Rob