use the INDIRECT() function

Activesheet.Range("A1").Name = "Vehicle" &
worksheets("Summary").Range("TempNumber").Value



"jeff" wrote:

Sheet named €œSummary€� contains a range name €œTempNumber€�.

I need a macro that will, within the current sheet, go to cell A1. It
will look at the range TempNumber and name the range (of cell A1) a
combination of the word €œVehicle€� plus the value in TempNumber.

Example: The value in range TempNumber is "Test1".
This macro will cause Cell A1 of whatever the current sheet is to be
named €œVehicle Test1€�
This will be used in different sheets, so I need it to do this in
whatever the Current Sheet is.

Thanks
j.o.