Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() A cell has the value=0.023. The Category is chosen as 'General' for this cell. I want to get the inverse of that cell value i.e. 0.023, and ignore the decimal point in the result. 1/0.023 = 43.478 = 43 Here is the excerpt from the macro: Line1 oneRequestTime = 1 / Worksheets("Banking").Cells("B4").Value Line2 Application.WorksheetFunction.Floor(oneRequestTime , 1) But, the 'Type mismatch' error is reported at the Line1. How do I get rid of this error. I tried to declare 'oneRequestTime' with different types. But, it did not help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
help with type mismatch error | Excel Programming |