Posted to microsoft.public.excel.programming

LJ[_3_]

external usenet poster

Posts: 8

What Range property distinguishes a double from a datetime?

I am using vs2005 and c#.

I am passing a range object into C# and trying to determine what type
of value it is. In case it's a datetime I want to convert it using
DateTime.FromOADate. I can't find the right property to help me
distinguish a datetime from a double. Excel seems to know. I see the
Range.NumberFormat looks different but using this seems like a real
kludge.

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
Property Let: assign return value of Double when passing String	Tetsuya Oguma	Excel Discussion (Misc queries)	1	March 3rd 06 08:01 AM
range property of range object	Woody[_3_]	Excel Programming	1	June 23rd 05 09:04 PM
Row and Column from Used Range property??	C. Johnson	Excel Programming	1	March 31st 05 07:51 PM
Range Resize property	jacqui[_2_]	Excel Programming	7	February 24th 04 06:11 PM
using a range with isnumber property	chick-racer[_33_]	Excel Programming	2	November 12th 03 06:53 PM

All times are GMT +1. The time now is 10:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us