Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Range Variables...
I have tried written the following code, however it's incorrect and I
can't seem to work out how to correct it. Could anybody offer any help please? Sub test() Range("A1").Select Dim Start As Range Set Start = ActiveCell Range("a5").Select Dim Final As Range Set Final = ActiveCell Range (Start:Final).Select End Sub Many Thanks Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Range Variables...
Hi
you need a comma not a colon Range(Start, Final).Select the colon goes in the text address for the range Range("A1:A5").Select or even Range(Start.Address & ":" & Final.Address).Select regards Paul On Feb 15, 11:39 am, "MarkHear1" wrote: I have tried written the following code, however it's incorrect and I can't seem to work out how to correct it. Could anybody offer any help please? Sub test() Range("A1").Select Dim Start As Range Set Start = ActiveCell Range("a5").Select Dim Final As Range Set Final = ActiveCell Range (Start:Final).Select End Sub Many Thanks Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Range Variables...
On 15 Feb, 11:48, wrote:
Hi you need a comma not a colon Range(Start, Final).Select the colon goes in the text address for the range Range("A1:A5").Select or even Range(Start.Address & ":" & Final.Address).Select regards Paul On Feb 15, 11:39 am, "MarkHear1" wrote: I have tried written the following code, however it's incorrect and I can't seem to work out how to correct it. Could anybody offer any help please? Sub test() Range("A1").Select Dim Start As Range Set Start = ActiveCell Range("a5").Select Dim Final As Range Set Final = ActiveCell Range (Start:Final).Select End Sub Many Thanks Mark- Hide quoted text - - Show quoted text - Thank you for your help Paul!! :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set few range variables at once | Excel Programming | |||
Range of variables | Excel Programming | |||
Describing a Range with Variables | Excel Programming | |||
Excel Range Variables | Excel Programming | |||
Range Variables | Excel Programming |