Thread: Repeat Macro until Empty Cell Reached
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
clpncsg clpncsg is offline
external usenet poster
  
Posts: 2
Default Repeat Macro until Empty Cell Reached
How do I repeat the following macro until it reaches an empty cell?

ActiveCell.Offset(0, 0).Select
Application.SendKeys ("{F2}")
Application.SendKeys ("{Home}")
Application.SendKeys ("{Del 5}")
Application.SendKeys ("{ENTER}")



Reply With QuoteReply With Quote