Prev: conditionally formatted list
Next: Array again limit
From: Isis on 3 May 2010 08:20
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
From: Dave Peterson on 3 May 2010 08:35
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
From: Gary Keramidas on 3 May 2010 08:38
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" <isissoft(a)NOSPAMbtinternet.com> wrote in message
news:Xns9D6D87E6EB513isissoft(a)193.202.122.122...
>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

From: Don Guillett on 3 May 2010 08:48
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
dguillett(a)gmail.com
"Isis" <isissoft(a)NOSPAMbtinternet.com> wrote in message
news:Xns9D6D87E6EB513isissoft(a)193.202.122.122...
>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

From: Isis on 3 May 2010 09:22
"Don Guillett" <dguillett1(a)gmail.com> wrote in
news:uobmy7r6KHA.2240(a)TK2MSFTNGP06.phx.gbl:

> 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,

 | 
Pages: 1
Prev: conditionally formatted list
Next: Array again limit