Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get column of named cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get column of named cell
Check your other post.
Isis wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get column of named cell
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 -- Gary Keramidas Excel 2003 "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get column of named cell
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get column of named cell
"Don Guillett" wrote in
: 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference Column of Named Cell vba | Excel Discussion (Misc queries) | |||
insert row into named column | Excel Discussion (Misc queries) | |||
Delete column if a cell is not named | Excel Programming | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Find first blank cell in single column named range | Excel Programming |