HOW TO: One name range to work for multiple sheets

K

Kevin McCartney

HI TWIMC,

Is there a way to enter one NAMED range that will work on all sheets in a
workbook? E.g. I'd like to be able to set the range A1:A10 as MyRange on
Sheet1 and I when I select Sheet2, and select MyRange, I want range A1:A10 on
Sheet2 to be selected and not A1:A10 on Sheet1.

Now I know I can select each sheet in turn and select the same range and
type in the NAME box sheetname!MyRange but it's a bit to much manual work for
a workbook with over 50 sheets and potentially the range required can change
shape per workbook, (not sheet).

Any ideas, much appreciated

TIA
KM
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoFilter Criteria using named range 4
Need Help with a VBA subroutine 0
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Problem using Range objects 1
Search an array of sheets for an array of numbers & return count of numbers 11
Array code only works on selected sheet 14
Sheet to sheet code Type Mismatch 6
Copy Array to Array, how to and should I? 13

Top