Excel VBA pass variable to named range

[acsmiamiguy]

Can't understand why this doesn't work...

Range(ActiveCell, ActiveCell.Offset.End(xlDown).Offset.End(xlToRight)).Select
PartID = Range(ActiveCell, ActiveCell).Offset(0, -2).Value
MsgBox (PartID)
Selection.Name = PartID

I selected a range of cells; set 'PartID' to pick up the value two cells to the left of the active cell; then tested it using a MsgBox, and it works. The MsgBox reads '100', which is the value I need to name the range. But when I use the Selection.Name = PartID I get an error. What am I missing here?
Thank you.

 

[footoo]

https://www.google.com.hk/search?q=....69i57j0l5.53291j0j8&sourceid=chrome&ie=UTF-8

 

[acsmiamiguy]

Just figured it out.... silly me. the value I was trying to use as a name was not valid.