Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+training+london - Excel VBA
|
|
|
The UK's most regular 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+training+london - Excel VBA
Resolved · Low Priority · Version Standard
Reply 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..
For upcoming training course dates see: Pricing & availability
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
|