Got it to work, but I need the first entry in column A to be the range name
Cell "A1" = "HP12"
Cell "B1" = "HP14"
etc...
Those headers are what I want as the range names, not the column number.