| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Problem with If formula and concatenate "&"
Very new to VBA.
I'm stumped. It seems very simple enough but I can't get it to work. I keep getting the Compile error: Expression expected ActiveCell.Offset(0, 8).Formula = IF(ActiveCell.Offset(0, 5)="MC","M" & ActiveCell.Offset(0, 6),"V" & ActiveCell.Offset(0, 6)) I've tried adding quotation marks at the beginning and end of the formula but when I run the macro it only writes the formula, not the result. Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| concatenate an "actionable" formula | Excel Programming | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming | |||
| Concatenate or "&" problem | Excel Worksheet Functions | |||
Threaded Mode
