| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a fixed cell in VBA using an IF statement
J,
thanks, Neil -----Original Message----- ActiveCell.FormulaR1C1 = "=IF(RC[-4]= ""h"",R1C19,""K"")" Neil Crawford wrote: Dear all, I'd be grateful for some advice on how to reference a fixed cell in a formula that I wish to copy down a row of cells. I'm writing some code to put a formula into a cell using an If statement. I want to pick up a value from a cell that is anchored ($S$1) but I can't seem to get it correct in the formula. I've also tried setting it up as a variable but that doesn't work either. The code below works except for the "=$S$1" part. ActiveCell.FormulaR1C1 = "=IF((RC[-4] = ""h,"=$s$1",""K"")" Any guidance would be gratefully received! thanks, Neil . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing text in an IF statement | Excel Worksheet Functions | |||
| Fixed/Locked cell referencing | Excel Discussion (Misc queries) | |||
| IF Statement: cell referencing | Excel Worksheet Functions | |||
| referencing cells including an IF statement??? | Excel Worksheet Functions | |||
| drawdown at fixed rate over set period from investment at fixed % | New Users to Excel | |||
Threaded Mode
