Thread: Looping Macro Doesn't Work
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
  
Posts: 718
Default Looping Macro Doesn't Work
Help. I can't seem to get this to work.

Sub Macro1()
Do While ActiveCell.Row < 7
Range("A" & ActiveCell.Row - 10).Select
Selection.ClearContents
Loop
End Sub

What did I do wrong?

Thanks
Rob
Reply With QuoteReply With Quote