Damn! you're good !!!
TXS
"KL" wrote:
this should work:
=SUBTOTAL(1,INDIRECT("Sheet2!C3:C"&Sheet2!B1))
KL
"Farrel" wrote in message
...
Hey txs for the Help
but why =SUBTOTAL(1,Sheet2!C3:Sheet2!(INDIRECT("c"&Sheet2! B1)))
doest work?
"KL" wrote:
Hi Farrel,
try this:
=INDIRECT("A"&B2)
Regards,
KL
"Farrel" wrote in message
...
I want to chage the row selection on a function by using a cell
reference
"A(B2)"
so when I change "B2" to 5
the function will read "A5"
TXS
|