| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula works when pasted, but not when typed
Your explanation is correct, but there's more to the story. Once one has
stored the formula in the cell, changing the format to numeric has no effect. This is an Excel/VBA bug that I'd encountered years ago but forgotten about. One must change the format to numeric _before_ writing the formula, as in the following two statements: ws.Cells(2, 1).NumberFormat = "0" ws.Cells(2, 1).Formula = "=SUBTOTAL(103,$A$3:$A$64000)" Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to use text typed in a cell C27 in formula Ex:Vlookup(C27.. | Excel Worksheet Functions | |||
| Typed or pasted text in a cell appears as #### | Excel Discussion (Misc queries) | |||
| formula typed contains an error | Excel Worksheet Functions | |||
| carriage return that works when pasted into a text file (eg. Notep | Excel Discussion (Misc queries) | |||
| How do I apply a formula to #s already typed in a series of cells | Excel Worksheet Functions | |||
Hybrid Mode
