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

That code by itself won't produce an infinite loop - it will check each
cell in the Selection then stop.

Do you have event macros running?

In article . com,
"Naji" wrote:

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