Posted to microsoft.public.excel.programming

external usenet poster

Posts: 10

can anyone tell me whats wrong with this line of code?

dim enddt
enddt = Range("c16").value
Range("d16").formula = "=if(" & endDt & " " & Date & " , " & Date &
" , " & endDt & ")"

What I am getting is in cell d16 is something like
"=IF(12/15/1999 1/5/2007, 1/5/2007, 12/15/1999)"
which is translating (displayed) as 1/0/1900
what i was trying to get is 12/15/1999
Cell d16 is formated a date m/d/yyyy
Thanks for any advice. BRC

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
Whats wrong with this code?	Steve[_73_]	Excel Programming	2	January 31st 06 04:13 PM
Whats wrong with this code?	Joseph[_54_]	Excel Programming	2	November 26th 04 04:31 PM
Whats wrong with this line of code?	Edgar Thoemmes[_4_]	Excel Programming	4	October 26th 04 12:52 PM
whats wrong with this code	LiSa	Excel Programming	2	September 8th 04 05:47 PM
Whats wrong with this code	gav meredith	Excel Programming	5	April 21st 04 12:01 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us