I am using Excel 2003.
I want to select and copy data using a macro but only want to select upto and including the last line of data,
could be one line could be 200 lines.
I am using the following at the moment.
Sub RangeSelect()
ActiveSheet.Range("a100:h100", ActiveSheet.Range("a100:h100").End(xlDown)).Select
Selection.Copy
End Sub
But this selects lines after the last line of data.
Any help would be great.
I want to select and copy data using a macro but only want to select upto and including the last line of data,
could be one line could be 200 lines.
I am using the following at the moment.
Sub RangeSelect()
ActiveSheet.Range("a100:h100", ActiveSheet.Range("a100:h100").End(xlDown)).Select
Selection.Copy
End Sub
But this selects lines after the last line of data.
Any help would be great.