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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display result of operation in macro
You're assigning a string to the pu variable. Just because it looks like a
worksheet formula doesn't mean that VBA will evaluate it. You could try: dim pu as long 'why use a double? pu = application.countif(worksheets("sheet1").range("e: e"), "*-p*") msgbox pu 'no ()'s required here orquidea wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display result of operation in macro
Thanks for your help. It worked
"Dave Peterson" wrote: You're assigning a string to the pu variable. Just because it looks like a worksheet formula doesn't mean that VBA will evaluate it. You could try: dim pu as long 'why use a double? pu = application.countif(worksheets("sheet1").range("e: e"), "*-p*") msgbox pu 'no ()'s required here orquidea wrote: 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 -- Dave Peterson |
Reply |
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) |