Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping cells though a named range
Hi
Can anyone give me an example of looping cells though a named range. Thanks Jo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping cells though a named range
On Tue, 19 Aug 2003 16:05:43 -0700, "Jo" wrote:
Hi Can anyone give me an example of looping cells though a named range. Thanks Jo In the example below, MyRange is a range name defined as =Sheet1!$A$1:$A$11 Sub LoopThroughRange() Dim rng As Excel.Range For Each rng In ActiveSheet.Range("myrange") Debug.Print rng.Value Next End Sub --------------------------------------------------------- Hank Scorpio scorpionet who hates spam is at iprimus.com.au (You know what to do.) * Please keep all replies in this Newsgroup. Thanks! * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping thru a range of cells | New Users to Excel | |||
Copy cells from named range | Excel Discussion (Misc queries) | |||
Copy cells from named range | 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) |