Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Why is this a incorrect statement? On the surface it appears corre

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,651
Default Why is this a incorrect statement? On the surface it appears corre

On Mon, 23 Jan 2006 06:51:05 -0800, "George Furnell"
wrote:

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


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


--ron
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
message box appears and appears Wanna Learn Excel Discussion (Misc queries) 1 January 14th 09 06:19 PM
Logical test in IF statement returning incorrect result Isabel Excel Worksheet Functions 3 December 13th 07 06:13 PM
3D Surface Map [email protected] Charts and Charting in Excel 3 September 9th 07 09:02 AM
NPV Calc appears incorrect with a large # of negative cash flows MikeW Excel Worksheet Functions 1 September 1st 05 03:31 PM
Surface Chart Help Alan Smith Charts and Charting in Excel 1 June 28th 05 09:11 PM


All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"