| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FInd common data in one column then add number in adjacent column | Excel Worksheet Functions | |||
| inverse of the column function? i.e. input a number, output thecorresponding column text label | Excel Worksheet Functions | |||
| How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| Auto number w/ different letter-number combos in same column | Excel Worksheet Functions | |||
Linear Mode
