| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving range string from named range
I have an input box that defines a range, which is then named, i.e. myRange.
Later in the program, I have need of the String version of the range that the user entered. To be specific, the following line of code DOES work: Sheets(i).Range("k26:k48").Value = Sheets(1).Range("k26:k48").Value However, the same line, using the SAME range, just in a named format, does NOT work: Sheets(i).Range("myRange").Value = Sheets(1).Range("myRange").Value Does this make sense? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Join non-contiguous ranges into one range via named range? | Excel Discussion (Misc queries) | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| If any cell in named range = 8 then shade named range | Excel Programming | |||
| Setting named range in VBA- how to set as formula/reference instead of text string? | Excel Programming | |||
Threaded Mode
