Get column of named cell

[Isis]

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

 

[Dave Peterson]

Check your other post.

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

 

[Gary Keramidas]

like dave mentioned in your other post, you should qualify your ranges with
sheet names

icolumn =sheets("Sheet6").range("staffheader1").Column
istaffname = "Isis"
Sheet6.Cells(3, iColumn + 1).Value = iStaffName

 

[Don Guillett]

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

 

[Isis]

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

Don and anyone else who was annoyed, sorry for breaking the rules and
thanks to everyone for the help.

Regards,