A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0-9 !@$* active | api | Application | array | chart | clipboard | color | date and time | debug | Error | file | filter | find | format | log | loop | named range | PPT | Pivot Table | record | udf | workbook | wrapper Continue at Database_code 948 Steps to 6 Figures by Learning Excel-VBA and Other Skills |

• | Activecell.formula | |

• | Value vs. formula | |

• | Selection. (formula, copy) | |

• | Activecell.formulaR1C1 = .... - code from macro recorder | |

• | [=1+2] - runs an xl formula in vba | |

• | GetSignature | |

• | Activecell.FormulatR1C1 | |

• | Convert formulas to values | |

• | Activecell.formulaR1C1 = | |

• | Activecell.formulaR1C1 = "=If(RC[-32]=0,0,RC[-10]/RC[-32] | |

• | VLookup as part of a formula with """ multiple quotes issue | |

• | Copy formula c7 - B7 and get weird values and need to do =if(c7="","",C7-B7)🔝 | |

• | Formula error =A1-B1/2 | |

• | Formula Error =C3-C2 and C2 is blank (if needed) | |

• | Evaluate formula tool | |

• | Debugging formula issues | |

• | Show Formula Mode - Ctrl ` | |

• | Formula vs. Value vs. Format | |

• | Formula Bar | |

• | Using fx to understand a formula | |

• | Covert Text date to date - cells(x,y).formula = cells(x,y).value (for all rows) |