| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display result of operation in macro
Hi All
I have the below subprocedure. I get the numerical right answer when it is displayed in a selected cell ie Range("A1"), but when I set it to be the equation of a variable I get "Run Time Error "13" Type Mismatch". Dim pu As Double pu = "=COUNTIF(Sheet1!e:e,""*-p*"")" MsgBox (pu) Could anyone explain to me why I am getting this error and how can I fix it? Thanks in advance and Happy Holidays! Orquidea |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA MACRO 4 ISNUMBER OPERATION | Excel Discussion (Misc queries) | |||
| can excel produce text in a given cell as a result of a boolean operation? | Excel Discussion (Misc queries) | |||
| Display message during save operation | Excel Discussion (Misc queries) | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Threaded Mode
