Posted to microsoft.public.excel.programming

Ashman

external usenet poster

Posts: 35

Strange Values

Hi all,

I am wanting someone to help me with my problem. I have a problem with dates.

Dim toDate, fromDate as string

toDate = sheets("data").cells(2,5).value
fromDate = Sheets("data").cells(2,27).value

The problem is that the value for toDate = 1/7/2001 and the value for
fromDate = "1/7/2002".

How do I take the "" out, I have tried everything? The only difference in
the above is the cell reference.

Can anyone help or suggestions would be great?

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
Strange	FreedomHillFarm	Excel Worksheet Functions	1	January 13th 11 01:12 PM
Strange?!	Jo[_2_]	Excel Discussion (Misc queries)	6	August 8th 07 07:01 PM
Strange behavior with text box values . . . help!	WillRn	Excel Programming	1	January 24th 05 10:14 PM
2 strange ones..	RC[_5_]	Excel Programming	0	November 15th 04 03:45 PM
Strange behavior Chart.SeriesCollection(n).Values property	Emile van Mierlo	Excel Programming	3	June 19th 04 06:07 PM

All times are GMT +1. The time now is 11:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us