|re: "I was hoping to name the columns and then reference the cell value using that name"|
When you say "name the column" I assume you mean a Named Range and not just a column label in Row 1.
This code will loop through all the Named Ranges in a workbook and return the Column number for the column that is named Name. In my example below, I'm simply presenting a Message Box with the column number.
If I needed to reference a cell, I would use the colNum variable in something like:
Set nms = ActiveWorkbook.Names
For r = 1 To nms.Count
If nms(r).Name = "Name" Then _
colNum = nms(r).RefersToRange.Column
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.