Select Last Cell - Blanks in between

[maverick_abhi]

Hi,

I am trying to write a macro that will help me select all the cells, till the last cell containing a value, including the blanks in between. how can i do this please help.

I am trying the following code:

Please Login or Register  to view this content.

Any Advice

[sweep]

Please Login or Register  to view this content.

[gajendra.gupta]

You can select your all data like this..

ThisWorkbook.Worksheets("EOM Drag").UsedRange.Select

Regards,
Gajendra Gupta

[mudraker]

Here is a few different ways to select last row & columns

Please Login or Register  to view this content.