Copy and paste formats/formulas between sheets

[100_Meridian]

Hello,

I have a need to maintain the format and formulas of a range of cells after user interaction. Users can enter data in the Main sheet and can potentially override formulas and formats. There are several reasosn why I have choosen this user capability and would rather not lock the cells.

To accomidate this I have a reference sheet with a copy of the range from the Main sheet with the correct formuas and formats.

This reference sheet contains other reference information and is not formatted very well. As such I prefer to keep it hidden.

Unfortnately my limited knowledge of VB is forcing me to activate the reference sheet to allow the copy. I then have to activate the Main sheet to allow the paste.

An example of my sheets and code is included here. Thank you in advance for any direction provided.

John

[ajaykgarg]

Hi John

Per my understanding, the code you have written is satisfying your requirements.
What help are you seeking?

Thanks
Ajay

[100_Meridian]

Yes the code I put togther does work. However I want to keep the reference sheet hidden, and would rather not have to select it, making it visible to the users, in order to copy from the source range.

My request is for assistance in calling a macro from one sheet that copies a range from a second sheet while keeping that source sheet hidden from the user. The paste portion of the code pastes format and formulas.

I have code that retrieves values from a hidden sheet but not format and formula attributes.

Thanks,

[ajaykgarg]

Can you unhide the sheet, copy, and hide the sheet after copying as below?

Please Login or Register  to view this content.

[100_Meridian]

I had considered this and will if it's my only option. The format of the reference sheet is not "user friendly" so I'd prefer to keep it hidden.