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 Training and help » excel+training+london - Excel VBA
excel+training+london - Excel VBA
Resolved · Low Priority · Version Standard
Fri 16 Nov 2007, 16:39Delegate Alex said...
Alex has attended:
Excel VBA Intro Intermediate course
Excel VBA
What is the line of code to select the range from cell A1 in the active work sheet to the last cell in the range (assume I would have assigned a variable to this last cell)? Hope that makes sense..
Wed 21 Nov 2007, 12:22Trainer Carlos said...
RE: Excel VBA
Alex
Youo need to set a variable to hold the defined range. Then you need to set the range as below.
NB The first "A1" sets the start, the second "A1" states that the range to select is only the A column.
Sub SelectRange()
Dim MyRange As Range
Set MyRange = Range("A1", Range("A1").End(xlDown))
MyRange.Select
End Sub
Hope this helps
Carlos
Training information:
See also:
|
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:Large Icons on toolbarYou can make the buttons on your toolbars bigger by going to Tools / Customize / Options / select Large icons. |
