Thread: Macro Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] atrscomputers@gmail.com is offline
external usenet poster
 
Posts: 21
Default Macro Help

Hey,

Can anyone tell me why i cannot do anything after this macro

Sub YCriteria()
Sheets("Macro Criteria").Select
For r = 2 To 100
If Cells(r, 2).Value = "Yes" Then Cells(r, 3) = Cells(r, 1)
If Cells(r, 2).Value = "" Then End
If r = 100 Then End
Next

Continue.Show

End Sub

Every time i add something after the Next it won't work. I can't call
another macro, call a userform, anything, and i really need it to :'(
If you can lend a hand it would be appreciated.

Thanks
Andrew