Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Macro to Copy

  1. #1
    Guest

    Default

    I need a simple macro to copy the formula from the cell that I have named “Formula1”, to the active cell.

    Can you direct me to articles about “Getting Started In Macros”? I am familiar with EXCEL recording the keystrokes and mouse clicks. I would like to read about writing the macro code to perform actions.

  2. #2
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sub CFormula()
    'By: Joe Was
    'Copy the formula from cell named "Formula1" to the active Cell.

    Range("Formula1").Copy
    ActiveCell.Select
    Selection.PasteSpecial Paste:=xlFormulas, Operation:=xlNone, _
    SkipBlanks:=False, Transpose:=False
    End Sub

    Copy this to a module or Right click the sheet tab and select view code and paste the code from above. Close the editor and select Tools-Macros-Macro highlight this macro and press options add the Hot-Key "c" as c. Close. Then when you select a cell and press Ctrl+c the macro will copy the formula in "Formula1" to your selected cell.

    To learn code, use the help function within the code editor. Help on a sheet is limited to sheet options. On the "View Code or Module" pages in the VBA Editor the help is for Visual Basic A. The help will give samples of how to use the code.

    Try making recorded macros universal by changing the code that was recorded. Change "Range("A1").Select" to "ActiveCell.Select" or other ref. and play with the code to make it do more or to remove the limitations put into the code by the recorder. This should get you started.

    To start: you need to name a macro, then tell the code where you are going to work, what you are going to work with, what you are going to do with your selection and how you want to end. JSW

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Washington State
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    One other way is to spend an hour a day reading this board. The first couple of days read the questions then look at the code that is posted by others in response to the question, which will give you a bunch of insight into how the logic of macros works.

    After a few days, or whenever you think you are comfortable with the logic and the commands, try this: Read a question here on the board that others have responded to, but DON'T read the responses. Take the question and develop a macro to solve it, then compare your code to some of the other solutions that have been posted, because usually there are several different approaches to solving a particular problem. You will find that you will learn more about VBA doing this.

    Hope this helps,

    Rick

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •