View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
 
Posts: 510
Default Check date and act on it

Hi,

Believe you are looking for something like :

If Sheet.Name = Text(month(yourcell),"mmm") then
your code
End If

HTH
Cheers
Carim