LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default Formula via VB error

The code you posted doesn't work? Or something else involving "SUME"? Your
code works for me as long as I have a value in Sheets("A").Range("A10").

--
Jim
"MM_KAT" wrote in message
...
| Hi,
| I am trying update formulas in cells via script. The formula is assigned
| correctly, but doesn't work. Instead of value there is #NAME? error tag.
But
| when I click on formula row in the sheet and pressing Enter - all become
| working! It appear with all simple formulas like SUME. I am desperate...
|
| For x = 1 To 5
| Range("A" & x).Formula = "=IF(B" & x & "=0,C" & x & "*" & _
| Sheets("A").Range("A10") & ",0)"
| Next x
|
| Thanks!


 
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
IF formula returns error; abbreviating the formula MZ Excel Discussion (Misc queries) 4 January 7th 10 11:02 PM
Formula Error BB New Users to Excel 3 December 3rd 07 05:00 PM
How do I replace "#N/A" error, to continue my formula w/o error? Ali Khan Excel Worksheet Functions 2 February 20th 06 03:49 PM
Formula error with Mac resulting in '#NAME' error Linking to specific cells in pivot table Excel Programming 2 August 1st 05 07:13 AM
Formula error... Jambruins Excel Discussion (Misc queries) 2 February 24th 05 09:57 PM


All times are GMT +1. The time now is 03:54 PM.

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

About Us

"It's about Microsoft Excel"