Posted to microsoft.public.excel.programming

external usenet poster

Posts: 846

Question about looping

What I want to do is to put the following two lines in a loop.

shtFixD.Rows("FixedFooter" & i).Delete
ActiveWorkbook.Names("FixedFooter" & i).Delete

Where I know the numbers start with 1 and increment by one. What I don't
know is how many "Footers" I have. How can I do this??

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Looping question	Jase	Excel Discussion (Misc queries)	2	March 19th 08 02:03 PM
Looping Question	MWS	Excel Programming	1	June 5th 06 08:17 PM
Looping question	Charles	Excel Programming	2	April 20th 05 11:32 PM
Looping Question	MWS	Excel Programming	3	November 12th 04 05:32 PM
Looping Question	MWS	Excel Programming	0	October 27th 04 01:49 PM

All times are GMT +1. The time now is 05:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us