ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   selecting a range (https://www.excelbanter.com/excel-programming/443818-selecting-range.html)

Wally

selecting a range
 
How would I select a range of cells 2 rows by 3 columns?

TIA

Gerry

Gord Dibben[_2_]

selecting a range
 
Sub test()
With ActiveCell
.Resize(2, 3).Select
End With
End Sub


Gord Dibben MS Excel MVP

On Mon, 25 Oct 2010 10:43:56 -0700 (PDT), Wally wrote:

How would I select a range of cells 2 rows by 3 columns?

TIA

Gerry



All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com