| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type Mismatch for a formula
Sheet1.Cells(11, col_Safety).Value = "=IF(INT(F11)=1,(" + Sheet1.Cells(7, col_Safety) + "+(MOD(F11,1)*" + Sheet1.Cells(7, col_Safety + 1) + ")),IF(INT(F11)=2,(" + Sheet1.Cells(7, col_Safety + 1) + "+" + Sheet1.Cells(7, col_Safety + 2) + "+(MOD(F11,1)*" + Sheet1.Cells(7, col_Safety + 2) + "))))" This formula keeps on giving me a Type Mismatch error... I'm using this in a macro instead of a formula because this is a weekly schedule and I don't want the numbers changing when it's not the current date. Can anyone see why I'm getting this error? Any help will be greatly appreciated! TIA :) -- cultgag ------------------------------------------------------------------------ cultgag's Profile: http://www.excelforum.com/member.php...o&userid=22677 View this thread: http://www.excelforum.com/showthread...hreadid=525835 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Type Mismatch?? | Excel Programming | |||
| Type mismatch using rnge as Range with Type 8 Input Box | Excel Programming | |||
| Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
| type mismatch--how to fix | Excel Discussion (Misc queries) | |||
| Type Mismatch | Excel Programming | |||
![cultgag[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
