| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA works fine but not in two workbooks. Help
Then you probably have calculation set to manual. Change it back to
automatic (Tools/Options/Calculation) In article , SLP wrote: Let me clarify a little more. When you run the code, what you see in all rows in Column E is what the value of the formula in cell E1 is. But if you go into each individual cell in Column E, you will see that the formula did get copied correctly but is now showing the proper results. If you manually enter the formula in say E3, you get the right results. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| xls file works fine in Excel 2000 and 2007 but crashes on opening in 2003 | Excel Discussion (Misc queries) | |||
| Visual Basic Function works fine in Excell 2003 but not in Excel 2 | Excel Discussion (Misc queries) | |||
| Pivot table is not valid in Excel 2000 but works fine in EXCEL 200 | Excel Discussion (Misc queries) | |||
| Works fine in debug, but... | Excel Programming | |||
| Automation error -2147417848 on windows 98 while using excel in VB ( works fine in XP) | Excel Programming | |||
Hybrid Mode
