Create range names with names in column heading

N

NigelVII

Hi,

Need some help.

I have a sheet that has column headings along row 1. Would like to create
range names with each column heading as the name. The number of rows will
increase.

Any suggestions?
 

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

Sum Columns with Specific Headings 6
Breaking One Row into Multiple Rows using VBA Macro? 2
Get Column Header Value 2
How to use structured reference (ListColumns) in VBA 2
Need to find the value within a matrix / table based on two other values 1
Find and match text and return column and row reference 0
define range using col and row names; not cell name 3
VBA CreateNames (ignores last 5 rows?) 6

Top