excelvbacode.com

Excel VBA Code.com

    


 Contents >

Excel Macros



Macros are the key to automating Excel.??

Macros can:
  • save time
  • Create functions missing from Excel
  • Do a number of Excel commands with one action
  • Increase your salary if you know how to write them

    A macro is series of statements that tells Excel to perform a specific function.

    An example would be to hide row 3 on the current spreadsheet.?

    ?Rows(3).Visible = False

    is macro code also known as VBA (Visual Basic for Applications) that will perform this function.

    A macro can be invoked via
  • Tools ? Macro ? Macros.. (2003)
  • View??? Macros (2007)
  • or press Alt+F8,

    select the Macro to run and pressing the Run button.??

    Excel comes with a Macro Recorder.??This tool is used to record your actions while using Excel.??You can then Run the macro which will replay the steps you?ve taken.??The beauty of macros in Excel is that if you don?t know how to code something but can do it via Excel, then you can have Excel show you how.??It?s not perfect, but it?s a great place to start.

    1.
     Recording Macros
    2.
     Finding Recorded Macros
    3.
     Modifying Macros
    4.
     Range
    5.
     Activecell
    6.
     Selection
    7.
     Cells
    8.
     Offset
    9.
     Objects ? Methods - Properties
    10.
     Word Wrap Example
    11.
     Macro Categories (25)
    12.
     Automation Basics
    13.
     Excel VBA (Visual Basic for Applications)
    14.
     Main VBA Statements (6)
    15.
     Routines and Functions (21)
    blog comments powered by Disqus
  • Home

    FAQ
    About

    Contact Us

    Excel Consulting
    987 Shirts
    Search Google & Bing