Whenever in doubt, record a macro if it allows Try this .Range “A” .Formula = “=IF Pivot!A=””””,A,Pivot!A “..Okay, a real simple way to insert code using VBA is done like this sheet.range a .formula = =b c However I need to do something more .I don t know how to insert this formula from my VBA code Note that the double quotes ” within the formula have been doubled to “”. This is .The formula is a string of text that is wrapped in quotation marks. The value of the formula must start and end in quotation marks. The formula string must start with an equal sign = after the first quotation mark..
0 Komentar