98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA
Excel VBA
Resolved · Low Priority · Version 2003
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?
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.
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 tip:Creating Quick Column ChartsSelect the information you want to appear in the chart and press F11. This creates a new chart on a seperate worksheet. |
