MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Stuck on copying formula from 1 sheet to another

  Asked By: Alma    Date: Nov 18    Category: MS Office    Views: 1359

I want to write
some VBA code I want to enter a formaula in sheet2 that will copy a
cell from sheet1. Sheet1 is active. sheet2 is not.



2 Answers Found

Answer #1    Answered By: Rene Sullivan     Answered On: Nov 18

Try recording what you want to do and then look at the code. That will give
you a start I'm sure.

If you don't know about recording a macro from the Tools menu then by all
means get back to us.

Answer #2    Answered By: Milton Robinson     Answered On: Nov 18

I'm not sure if this is what you are asking for.

This will copy  a formula  from sheet1  into a cell on sheet2:

Another option:

Sheets("Sheet2").Range("A3").Formula =

By using the command Sheets it doesn't matter who is active.

Remember, it's better to use variables than strings ("Sheet1", "Sheet2", "A3")
. It uses less memory and the macro runs faster.

Didn't find what you were looking for? Find more on Stuck on copying formula from 1 sheet to another Or get search suggestion and latest updates.