VBA code snippet to select entire data

[Karthik Thandapani]

Hi,

Can anyone please provide a vba code snippet to select entire data in the table. The purpose is to capture this data & to paste it in another table the same way.

If possible, please make the selection criteria as dynamic.

Many thanks in advance. Please see the attached file.

 

[Hui]

How about:

Range("I4").CurrentRegion.Select

 

[Karthik Thandapani]

@Hui , thanks, I think I can do with this!
Only drawback is: If a row with no data then this wont find the next available dataaaa

 

[Hui]

The problem is that without Row or Column Headers what defines the extent of the data

Can Column B have blanks or is it always full?

 

[Chris Macro]

I like to use this:

ThisWorkbook.Worksheets(1).UsedRange.Select