How to find the range of cells(Only having data) in a sheet using vba?

[krkarthik]

Hi,

I would like to find the range of cells in a sheet which looks like as given below. Assume that in the last two columns, data was entered and later on deleted.

Name	04/17/2015	04/18/2015
ABC	10	11
XYZ	50	60
KMN	10	05
RTW	45	60

How do I get only the range of cell which is currently having some values in it? Kindly help.
Note: I tried using 'UsedRange' which gives the cell range including last two columns.

Thanks in advance.

[jaslake]

Hi krkarthik

Something like this perhaps

Please Login or Register  to view this content.

[mehmetcik]

Closing and reopening the file should reset the used range.

Failing that.

Please Login or Register  to view this content.

[krkarthik]

Hi jaslake,

Thanks for the reply. Your code helped me to solve my scenario.

Thank you.

[krkarthik]

Hi mehmetcik,

Thanks for the reply.

Thank you.

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.