Get column of named cell

I

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
 
D

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
Click to expand...
 
G

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
 
D

Don Guillett

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

Isis

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

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

Regards,
 
Top