Select last row and then...

[siobeh]

Hello,

Could anyone please help me with my problem.

I just want to:


1. Select the last row of Column B
2. After selecting it, then CTRL A ( select all ) and then move 1 row for the header is not included.

Highlighted rows should be selected.

Thanks in advance!

[Steve@Rugby]

Hi,

Not sure what you need here, can you try to explain a little more please?

Regards
Steve

[Ron Coderre]

Try this Sheet1 vba code

Please Login or Register  to view this content.

Does that help?

[siobeh]

Hello Steve,

I just want to select A1-J, but since some rows in Column A have no data (when i 'ctrl-a' some data in column a is not captured), i have to go to in Column B due to all rows of it have a data, then 'ctrl a' to select all but not including the header. Sorry for my bad english.

[siobeh]

Hi Ron,

That's what i need!

Could you please explain the code per line?

[Ron Coderre]

Regarding this code:

Please Login or Register  to view this content.

Since I refer to the CurrentRegion several times, I constructed a With/End With section so I could refer to it with a period.

Please Login or Register  to view this content.

That means the CurrentRegion that includes cell A1

In this section:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

means: CurrentRegion.Rows.Count

Please Login or Register  to view this content.

means: CurrentRegion.Columns.Count

and this:

Please Login or Register  to view this content.

refers to the bottom right corner of the CurrentRegion

This section:

Please Login or Register  to view this content.

refers to the range with A2 in the upper left and the bottom right corner of the CurrentRegion

I hope that helps.

[siobeh]

Thanks Ron! it helps a lot!