Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2006

Tip: Looking for answers? Try searching our database.

Why is this a incorrect statement? On the surface it appears corre

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
George Furnell - 23 Jan 2006 14:51 GMT
The following statement causes an error message, but it appears (to me) to be
ok.

The statement is Range("A1").Value = 5, and the error message is "A value
used in the formula is of the wrong data type"

Please assist.

George
Ron Rosenfeld - 23 Jan 2006 15:06 GMT
>The following statement causes an error message, but it appears (to me) to be
>ok.
[quoted text clipped - 5 lines]
>
>George

Unless someone has a better idea, you'll need to post more of your code.  That
single statement is valid standing alone.

--ron
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.