Here is my code. If i hardcode the tmpTankCol variable to be 'A' or 'B' or
any other letter it works, when i run the code this way i get the "the
formula you typed has an error" message


tmpTankCol = ActiveCell.Column
Names.Add Name:=newName, RefersTo:="='POLARIS Tank Temp Input'!$" &
tmpTankCol & "$2:$" & tmpTankCol & "$13"

Thanks!!!
HckyGirlOH






"Norman Jones" wrote:

Hi Hckygirloh,

It should not be necesasary to convert the column number.

Post your problematic code.


---
Regards,
Norman


"Hckygirloh" wrote in message
...
When retrieving the column of a cell in these types of technques is there
a
way to retrieve the column as a text character? I am trying to create
names
in a loop and the column is dynamic so i use the activecell.column
function
to retrieve the column. The name function gives me an error that the
formula
you typed has an error. If I hard code my variable to be a letter instead
of
a number it works.

thanks!
hckygirloh