I need to cycle through some named ranges (zones) and perform actions on the cells withing those ranges. I have worked out the actions that take place in the individual ranges and now want to cycle through the ranges. Im getting an OBJECT REQUIRED error when I try to pass the "name" of the names ranges into the range.
there are 4 zones named:
zoneAPrng
zoneASrng
zoneFPrng
zoneFSrng
Ive tried several variations after reading the help on the error but am at the point that Im just easter egging. Each thing produces a new error.
Set me strait please
Robert
Bookmarks