Macro With Names

[Drewa25]

I am trying to make a marco that will define a name starting with Spot_001 that refers to Master!$A$2:$M$2 and repeats through Spot_089 or row 99. Ideally it would name as the contents of column A

 

[Jeffrey Lopez]

Is Spot_001 in A2?

So can I assuming that A3 would be Master!$A3:M$3?

 

[Drewa25]

Correct, Spot_001 is in A2 and A3 would be Master!$A3:M$3

 

[Jeffrey Lopez]

Here is something I wrote up the other day, think it should work for you, all you need to change is where the data starts (A1 or A2) but either way this should work for you.

PLEASE BACK UP YOUR EXCEL FILE BEFORE RUNNING THIS MACRO

Sub NamedRanges()

Dim rngCell As Range
Dim intLstRow As Integer

intLstRow = ActiveSheet.UsedRange.Rows.Count
counter = 2 'If the data starts in A1, changes this to 1

For Each rngCell In Range("A2:A" & intLstRow) ' If the data Starts in A1, changes this to A1
ActiveWorkbook.Names.Add Name:=rngCell.Value, RefersTo:=Range("Master!" & rngCell.Address & ":$M$" & counter)
counter = counter + 1
Next


End Sub

PLEASE BACK UP YOUR EXCEL FILE BEFORE RUNNING THIS MACRO

 

[Drewa25]

Thank you!! Works just as I had hoped