Cell Address by slider

[Mike Slattery]

I need to display data in a cell based upon a scrolling counter.

How do I split a cell address using the first Col Ref Letter like "BH" and append the counter to provide me with the row number which has been provided the data label of PCOUNT.

Thanks, Michael

 

[shg]

=indirect("BH" & PCOUNT)

 

[Mike Slattery]

Worked great ;√)

Thanks, Michael

 

[shg]

You're welcome.