Finding the last row or column containing data?

[Joozh]

Hi,

I have recorded a macro which copies a fixed range of cells and pastes the selection where the cursor is placed before running the macro. I always paste these cells 2 rows after the last row of my sheet. The problem with the macro is that if my cursor is placed anywhere but the desired location, it messes up my sheet

How can I modify my macro so that it always pastes the selection 2 rows after the last row containing data?

Also can I do something similar fo rcolumns? i.e how can I find the last column containing data?

Regards,

- J

 

[gnaga]

Hi,

I have recorded a macro which copies a fixed range of cells and pastes the selection where the cursor is placed before running the macro. I always paste these cells 2 rows after the last row of my sheet. The problem with the macro is that if my cursor is placed anywhere but the desired location, it messes up my sheet

How can I modify my macro so that it always pastes the selection 2 rows after the last row containing data?

Also can I do something similar fo rcolumns? i.e how can I find the last column containing data?

Regards,

- J

For selecting the last row containing data in column A
Range("A65536").End(xlUp).Select

For selecting the last column containing data in row 1
Range("IV1").End(xlLeft).Select

GNaga