| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to return a range
Dim myRange as Range
Set myRange = Range(Cells(),Cells()) "NDBC" wrote: I need to return a range to send it to a function. This is what I am using Set ranger = Range(Cells(TRow, 14), Cells(TRow, TCol + 3)).Address It doesn't seem to work. All the variables are correct in debugger but the ranger (dim as range) is "nothing". Thanks again |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return date if in range, else return blank | Excel Worksheet Functions | |||
| drop first row in range and return a new range object | Excel Programming | |||
| Return Range Address from Active Range | Excel Programming | |||
| return min. of range except 0 | Excel Discussion (Misc queries) | |||
| Return to range | Excel Programming | |||
Threaded Mode
