| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA reference to 3D range
I am trying to do a For..Each..Next on a 3D range but can't quite nail the
range variable. The range is A2:F15 in 9 worksheets. Dim rng As Range, c As Range Set rng = Range(Sheet1:Sheet9!A2:F15) 'here's my problem For Each c in rng If c = "-999" Then c = "" ElseIf c 50 Then c = c / 1000000 End If Next Mike F |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| Can you get the range reference for each page in a worksheet print range? | Excel Programming | |||
| adding reference-to-range control to excel range | Excel Programming | |||
| Range Reference | Excel Programming | |||
| Subscript out of Range on Range reference | Excel Programming | |||
Threaded Mode
