Select the same range across all sheets and make them static

[billj]

Hi everyone,

My workbook has over 30 sheets. I can select some range in Sheet1 and use copy/paste to make data static in this range. But I want to repeat this to all sheets in the workbook. How a macro can help?

I recorded a macro as below (not very clever):

Please Login or Register  to view this content.

[mrice]

try

Please Login or Register  to view this content.

[davesexcel]

Possibly:

Please Login or Register  to view this content.

[billj]

Hi everyone,

Sorry to mention that the rows 7:8 are just an example. I need to make it flexible by selecting any range in a sheet and make that range static, and this will be replicated to all other sheets. So the first step is to get the selected range's address and apply this to all other sheets.

[davesexcel]

You can get the selection address

Please Login or Register  to view this content.

[billj]

Many thanks, sir. It works well now.