Excel VBA

Resolved · Low Priority · Version 2003

Excel VBA

Jane has attended:
Excel VBA course

by - delegate Jane [1 post] (2008 Jul 3 Thu, 16:39) Reply

what is the code to select a range from the anchor point downwards a specified number of rows?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel VBA

by - delegate Colin [6 posts] (2008 Aug 4 Mon, 12:59) Reply

If you have the number of rows specified as a variable (NumOfRows) then

Range(activecell.address, activecell.offset(NumOfRows,0).address).select

Otherwise if you want to select 6 rows, you need to offset your selection by 5 rows as shown below:

Range(activecell.address, activecell.offset(5,0).address).select

Generally:

Range(activecell.address, activecell.offset(NumOfRows,NumOfColumns).address).select

where NumOfRows and NumOfColumns are the EXTRA rows and columns you want to select IN ADDITION TO the currently selected cell.