Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range
Substitute
For Each clCell in Range("NamedRange") Alan Beban Mark M. wrote: I have a named range that is 10 rows by 10 columns. If possible, I'd like to use the "For Each" construct to go thru the range. Could somebody give me some sample code? I would think the code would look some thing like this: Dim clCell as Cell For Each clCell in NamedRange if clCell.Value = 10 then clCell.value = 20 Next clCell Thank you for your help, MarkM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range
Thanks for the help.
Mark M. -----Original Message----- Substitute For Each clCell in Range("NamedRange") Alan Beban Mark M. wrote: I have a named range that is 10 rows by 10 columns. If possible, I'd like to use the "For Each" construct to go thru the range. Could somebody give me some sample code? I would think the code would look some thing like this: Dim clCell as Cell For Each clCell in NamedRange if clCell.Value = 10 then clCell.value = 20 Next clCell Thank you for your help, MarkM . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel |