LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Searching for name series

Hi all,

I have a series of names defined as

defMac1
defMac2
defMac3
....
defMac18
I'll like to write a code to look for each name and do other code,
everything inside a loop.
Something similar to:

Sub defmac()
Dim n As Name
Dim x as Integer
x = 1
For Each n In ActiveWorkbook.Names.Item(defMac(x))
i=i+1
x=x+1
Next n
Msgbox i
End Sub

Of course this code doesn't work , but hope you get the idea. Anny ideas.

Thanks.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Program Speed - Arrays Searching vs. Row Searching CWillis Excel Programming 8 June 4th 09 06:42 PM
Fill Series Dates: not letting me change the series from year to m Mike Excel Discussion (Misc queries) 1 January 24th 08 05:08 PM
Searching, matching then searching another list based on the match A.S. Excel Discussion (Misc queries) 1 December 13th 06 05:08 AM
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM
series graph -- one series being added to another series rich zielinski via OfficeKB.com Charts and Charting in Excel 3 March 30th 05 06:23 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"