View Single Post
  #1 (permalink)  
Old December 19th, 2005, 06:49 AM
crmpicco crmpicco is offline
Friend of Wrox
Points: 8,019, Level: 38
Points: 8,019, Level: 38 Points: 8,019, Level: 38 Points: 8,019, Level: 38
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default check dates against each other from differentrange


Code:
'... if the cells are not empty then change the number format '... to the date format DD MMM YY If Range(sRange).Text <> "" Then Range(sRange).NumberFormat = "dd mmm yy" End If If Range(sTempRange).Text <> "" Then Range(sTempRange).NumberFormat = "dd mmm yy" End If

Is there a way to check if the text/value inside sTempRange is not earlier than the text/value inside sRange??

For e.g. I have a problem in my sheet as sRange = 29-Dec-05 and sTempRange = 31-Mar-05.

Can i do a check or something for this?

Thanks.

Picco

www.crmpicco.co.uk
__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk