Please do not waste responders time and effort by posting in more than ONE
group. See ans in .misc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Isis" wrote in message
...
I have a named cell - StaffHeader1 - I want to refernce just the Column
property of this cell in another piece of vba - how do I do that ?

So in my code I am going to do this;
iColumn = Column(StaffHeader1)
Sheet6.Cells(3, iColumn + 1).Value = iStaffName

Any help appreciated

Thanks