Thread: Macro - update the cell to the left after a find
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default Macro - update the cell to the left after a find
Use this instead:
ActiveCell.Offset(0,1) = "n/a"

Merjet


Reply With QuoteReply With Quote