Thread
:
Loop macro for a Newbie
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Loop macro for a Newbie
try
Sub gothereif()
If Cells(15,8) =0 Then Application.Goto Sheets("view").Range("a1")
End Sub
--
Don Guillett
SalesAid Software
"mike" wrote in message
...
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
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]