Selecting data from column and stop at the last column with data

[SteynBS]

Hi guys,

I have this vba code

Range("A1:B" & Range("A" & Rows.Count).End(xlUp).Row).Select it selects data in column A and B but stops at the last row with data in Column A.

Now I need something that does it for rows.

Let's say selecting data in Column A from row 2 (may change) up until the last column with data in it and the last row with data

Any help will be appreciated

 

[ctgcwiqc]

You will need to loop through each column to determine last row for both and then use the lowest row as "lastrow". I will post a sample shortly.

 

[ctgcwiqc]

Hi guys,

I have this vba code

Range("A1:B" & Range("A" & Rows.Count).End(xlUp).Row).Select it selects data in column A and B but stops at the last row with data in Column A.

Now I need something that does it for rows.

Let's say selecting data in Column A from row 2 (may change) up until the last column with data in it and the last row with data

Any help will be appreciated

I thought I read your post correctly but re-read it and not sure exactly what you mean. Can you expand a little please?

 

[Fluff]

Does this do what you want

ActiveSheet.UsedRange.Select

 

[SteynBS]

Does this do what you want

ActiveSheet.UsedRange.Select

This can work yes, thank you

 

[Fluff]

Glad we could help & thanks for the feedback.