How to prevent name range from changing

T

Tang

I have a range name "Address" refer to A1:A10. However, when i move the data
in A1:A10 to B1:B10, the reference of "Address" also moved to B1: B1.

My question is: How to prevent "Address" from being move to B1: B10 even
though i move the data in A1:A10.
 
A

Alok Joshi

Tang,
Create a range name and in the Refers To enter =INDIRECT("A1:A10")
Alok
 

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

VBA Coding Help for Beginner 0
range names 4
VBA for Dependents shortcut menu 0
Unique Value Count in 3 Columns Using Search Criteria 0
macro for a range 0
Insert name and adress from a list in a word document 1
Validation Against another Cell 2
help! 4

Top