Microsoft Office Forums - View Single Post - Use of named ranges based on cell content

Thread: Use of named ranges based on cell content

View Single Post

Old

02-24-2019, 11:27 AM

Intruder

Intruder is offline

Intruder uses Windows XP

Windows XP Intruder uses Office 2007

Intruder uses Office 2007

Office 2007

Advanced Beginner

The original poster

Join Date: Dec 2010

Posts: 59

Intruder is on a distinguished road

Default

Agree, but I would use the last digit (1, 2, ..) for the sub copied from another cell, as such ‘sub_’ will be constant but extended with this number to ‘sub_1’ and to be used in a formula

Reply With Quote