Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel VBA
Resolved · Low Priority · Version 2003
Reply Thu 3 Jul 2008, 16:39Delegate Jane said...
Jane has attended:
Excel VBA Intro Intermediate course
Excel VBA
what is the code to select a range from the anchor point downwards a specified number of rows?
For upcoming training course dates see: Pricing & availability
Reply Mon 4 Aug 2008, 12:59Delegate Colin said...
RE: Excel VBA
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.
|