Error running in Macro active sheet

[Himanshu]

Hi Everyone,

Hope everybody is doing good.

I have a strange issue. I've recorded a macro on Sheet3 and gave short cut key to it and it works fine whereas when i am assigning this macro to a button on sheet1 and when i run it, i am getting an error message and its taking me to VBA module and its highlighed in yellow.."active sheet something"..How do i able to run this macro by assinging to a button on sheet1.


Thanks in advance.

 

[Hui]

Can you post your code please

 

[vasim]

The most common problem, since you have recorded the macro would be the "sheets name". You would have not given the exact sheet path to the range defined.....however as advised by Hui post your code...