View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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