VBA reference to 3D range
VBA doesn't support 3D ranges. A range object has a parent. A 3D range
can not comply with this.
--
Regards,
Tom Ogilvy
"Mike Fogleman" wrote in message
...
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
|