Delete a range of cells, using a variable as the cell description.

[KevAmiga]

Hi all, using Excel 2003, I have 2 sheets side by side. I need to find the last Row on sheet A, and on sheet B use that value to delete any further Row's, so

Say on Sheet A, data runs from row 1 to row 35. I have identified that row 35 is the last row, and saved that as a variable "LastRow"

I then need to delete Rows 36 > 999 on sheet B.

Any ideas?

This should be easy, i know. But for some stupid reason I cannot get it to work

Kev

[millz]

Try:

Please Login or Register  to view this content.

[KevAmiga]

Awesome ill give it a go tomorrow - Cheers Millz