Error 1004 : in macro

[greenman]

hi,

Can you please tell me what i have done wrong here, the macro worked fine when I had placed the button in the copying sheet, but it was copying the macro button along with it. So I moved the button to different sheet and now I keep getting this run time error. Can someone please help me?

Sheets("Expense Vs Exams").Activate
Range("A3").Select

 

[mvptomlinson]

Perhaps:

With Sheets("Expense Vs Exams")
    .Activate
    .Range("A3").Select
End With

 

[greenman]

Thanks for the quick reply, however if i do that then the macro does not go back into same workbook.

Windows("Expense Tracking Base.xls").Activate

 

[mvptomlinson]

What?

 

[greenman]

The Macro that I have basically copies list of Names from the range specified and paste each each Name into Sheet 1- A3. runs Calculation based on data in A3 and copies the sheet into new spreadsheet.

And if i use your code it does not go back into the orginal spreadsheet.

 

[greenman]

Never mind I found the issue and have solved this. Thanks for your help.