Introduction to VBA Programming

 

                                                e, j, l, m, q, t

                  Used Ctrl+Shift+key combinations:

                        Use any except

    •               F, O, P

    •  

  •  

           8. GetFormula

                              Function GetFormula(ThisCell)

                                  GetFormula = ThisCell.Formula

                              End Function

     

          9. Recording macros

                            Tools > Macro > Record New Macro

                  

         10. Control structures

                            If ..... Then ..... Else

                                        For ... Next