Posted to microsoft.public.excel.programming

CRayF

external usenet poster

Posts: 115

What variable would I use to aquire Today()

I have this working except that I want 09/19/05 to equal Today()'s date
What would this line need to look like?
Range("Q4") = "09/19/05"

------------
If Target.Address = "$P$4" Then
If Range("Q4") = "mm/dd" Then
Range("Q4") = "09/19/05"
Range("C12").Select
Else
Range("Q4") = "mm/dd"
Range("Q4").Select
End If
End If
------------

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Today variable to calender control	anonymous	Excel Discussion (Misc queries)	2	March 10th 05 03:22 PM
Sub to aquire list of worksheets	aking1987[_9_]	Excel Programming	4	November 17th 04 05:27 PM
Sub to aquire list of worksheets	aking1987[_14_]	Excel Programming	3	November 17th 04 04:37 PM
Sub to aquire list of worksheets	aking1987[_11_]	Excel Programming	3	November 17th 04 03:57 PM
Sub to aquire list of worksheets	aking1987[_13_]	Excel Programming	0	November 17th 04 03:44 PM

All times are GMT +1. The time now is 03:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us