Posted to microsoft.public.excel.programming

mike

external usenet poster

Posts: 216

Loop macro for a Newbie

I would like to be able to move to a specific page in my
spreadsheet when a condition is met. I need this to work
in one of my existing macros.

ie

When cell(15,8)=0
go to
Sheets("view").Select

otherwise
ActiveSheet.Calculate

Loop back.

How can one write a simple loop program?

Thanks and Happy new year.

Mike

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
VBA Newbie: Help with Do Loop code	Carl	Excel Discussion (Misc queries)	3	December 2nd 04 07:04 PM
Macro Help for Newbie	Phil	Excel Programming	2	October 15th 03 04:57 AM
newbie: stop a FOR NEXT loop	Mike H[_7_]	Excel Programming	4	October 11th 03 04:47 PM
Newbie. Please help me find a loop solution	Nigel Brown[_3_]	Excel Programming	1	July 16th 03 02:48 PM
Newbie. Please help me find a loop solution	Nigel Brown[_2_]	Excel Programming	0	July 16th 03 10:25 AM

All times are GMT +1. The time now is 06:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us