Row or column number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arguments of Excel functions 2
Column number of last column that returns value ignore formulas 8
Problem with a loop and column references 27
convert columns to rows 6
Excel Concatenate with line breaks but ignore blank cells 3
Random selection of records based on specifc value 5
For-Next by a row Counting consecutive Zero in the column 4
Copy columns and paste with blank column between 5

Back
Top