Select dynamic range based on non-empty cells

Greetings,

I require code to identify the last row in column 'A' that contains data, and then to select every row up to that one, and each column up to 'H'. My data begins on row 3, and the rows with data varies from row 7 through 120. The columns with data is constant so there is no need to test in that direction.

Many thanks,
AM

One way

Please Login or Register  to view this content.