Row or column number
 

Is there any way to utilize a row or column number as a function parameter in
Excel? I like to extract 64 HEX numbers from 64 consecutive rows in a column
and concatenate them as a single string. Thanks in advance.

Row or column number
 

Soonh,

I'm not sure if this is what you're asking, but you can use "activecell.row"
or "activecell.column" to get the current row and column. The same thing
works for any specified range.

Eric


"soonh" wrote:

Is there any way to utilize a row or column number as a function parameter in
Excel? I like to extract 64 HEX numbers from 64 consecutive rows in a column
and concatenate them as a single string. Thanks in advance.