| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to define a Range with variant?
Hi all,
I would like to define a range with variant in VBA program. For example, inside a for-loop, when i=1, the selected range is Range("A1":"F1"); when i=2, the selected range will be Range("A2":F2") and so on. But I don't know how to define such "Range". Can anyone help me? Thanks a lot!! C.F. Yiu |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define a range | Excel Discussion (Misc queries) | |||
| How do I assign range to variant and use | Excel Discussion (Misc queries) | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| Best way to paste a variant array into a range? | Excel Programming | |||
| Testing if Variant is Range or Double? | Excel Programming | |||
Threaded Mode
