| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass a string to an address
I answered my question with this test:
Public Sub changerange() Dim myStrg As String Dim myrange As Range myStrg = "A3" Set myrange = Range("a1") myrange.Select Set myrange = Range("a2") myrange.Select Set myrange = Range(myStrg) myrange.Select End Sub sometimes I have to go back to the basics, WAY back, that is |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pass Cell Address to OFFSET | Excel Worksheet Functions | |||
| How to pass address(es) as parameters | Excel Programming | |||
| pass cell value as string to function | Excel Programming | |||
| Pass string value to another form | Excel Programming | |||
| Pass string as Parameter in OpenText method | Excel Programming | |||
Hybrid Mode
