Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default selecting a range

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

TIA

Gerry
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 621
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Proper syntax for selecting a range using cells instead of range JasonK[_3_] Excel Programming 4 July 22nd 09 07:01 AM
Selecting range in list of range names depending on a cell informa Courreges Excel Discussion (Misc queries) 2 June 19th 06 10:59 AM
selecting a range jhahes[_12_] Excel Programming 1 July 5th 05 08:57 PM
Help please in selecting range dependent on another range MickJJ Excel Programming 2 January 10th 05 12:01 PM
Selecting a Range inside a range hcova Excel Programming 0 July 13th 04 03:26 PM


All times are GMT +1. The time now is 09:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"