I have an excel worksheet which has a reference to another sheet (='Order
Numbers'!E448) I want to be able to replace the row number “448� with number
that I would put in. I would leave the column designation as is. How can I
accomplish this?
Wayne

if this is a spreadsheet function then you could use

=INDIRECT("'Order Numbers'!E" & B3)
where Cell B3 has the row number, ie :=448

In VBA you could pass it as a parameter ...

DIM Cell As Range
DIM rownum As LONG
rownum = 448
SET Cell = Cells(rownum,"E")

"Wayne26el" <(E-Mail Removed)> wrote in message
news:363B7187-B913-48C4-8108-(E-Mail Removed)...
> I have an excel worksheet which has a reference to another sheet (='Order
> Numbers'!E448) I want to be able to replace the row number “448� with
> number
> that I would put in. I would leave the column designation as is. How can I
> accomplish this?
> Wayne
>

=INDIRECT("'Order Numbers'!E" & B1)

Enter a number in B1


Gord Dibben MS Excel MVP

On Tue, 19 May 2009 11:16:04 -0700, Wayne26el
<(E-Mail Removed)> wrote:

>I have an excel worksheet which has a reference to another sheet (='Order
>Numbers'!E448) I want to be able to replace the row number “448” with number
>that I would put in. I would leave the column designation as is. How can I
>accomplish this?
>Wayne

=index('order numbers'!e:e,a1)
where a1 contained that number

or with minor validity:

=if(a1="","",index('order numbers'!e:e,a1))



Wayne26el wrote:
>
> I have an excel worksheet which has a reference to another sheet (='Order
> Numbers'!E448) I want to be able to replace the row number “448� with number
> that I would put in. I would leave the column designation as is. How can I
> accomplish this?
> Wayne

--

Dave Peterson