Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I really feel stupid on this one, but it's 4am here, so maybe you'll cut me
some slack. Code: Dim CrntA As String CrntA = Range("A41").Select [some stuff] Range("CrntA").Select Issue: I want to return to A41 using the variable, so I can change the variable and loop the code, but try as I might, my Range.Select method isn't taking me anywhere. Error Code: (approximately) Run-time error '1004' Method 'Range' of object '_Global' failed Question: How do I properly set up a variable, and use it to return to the cell I used as the variable. Hope someones out there early on a Sunday. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I call IE browser (Back button) through Excel macro? | Excel Discussion (Misc queries) | |||
How can I call IE browser (Back button) through Excel macro? | Excel Discussion (Misc queries) | |||
A 64-bit variable from VBA to VC++ dll and back to VBA | Excel Programming | |||
clipboard forgets on call back | Excel Programming | |||
Using variable to call worksheets | Excel Programming |