Get column of named cell

  • Thread starter Thread starter Isis
  • Start date Start date
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
 
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...
 
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
 
Please do not waste responders time and effort by posting in more than ONE
group. See ans in .misc
 
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,
 
Back
Top