View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Naji
 
Posts: n/a
Default For Next Infinite Loop

I am getting an infinite loop when I run this code and today's date
isn't found. I'd like it to do nothing if it's not found. How would I
do that ?

For Each rCell In Selection
If rCell.Value = Date Then Range(rCell.Address).Offset(1, 0).Activate




Next rCell