Range Function

[Bass71]

Thanks for the info, it was most helpful. However, I am looking to highlight the rest of the sheet to the right and downward from a given cell in the A column.

Basically, it is the equivalent of <ctl> <shft> Right arrow, Down Arrow.

Is this code valid:::

Range(ActiveCell, ActiveCell.End(xlDown), ActiveCell.End(xlToRight)).Select


Thanks

 

[siqual]

Close, I think what you want is this:

Range(ActiveCell.End(xlDown), ActiveCell.End(xlToRight)).Select

You can select a range either down and over or over and down. Shouldn't matter if the data is rectangular. If not then things could get a bit more complicated.