| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba variable value via cell reference
S = Range("G" & X)
"Bill (Unique as my name)" wrote in message oups.com... I do not know the proper syntax for the fourth line of this sample code. 1. Dim S as Long 2. Dim X as Long 3. For X = 5 To 55 4. S = Range("G&'X'&") 5. Next x Please change my gloomy day to a bright shining wonder. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Cell Reference Math | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Threaded Mode
