| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting the row/column number
Hi, How can I get the row and column number into variable x to use it late on in the mcaro? Thank -- micha ----------------------------------------------------------------------- michal's Profile: http://www.excelforum.com/member.php...fo&userid=2440 View this thread: http://www.excelforum.com/showthread.php?threadid=38006 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting the row/column number
the row and column number of what? If row number and column number of selected cell it is dim x1,x2 as variant x1=Selection.Row x2=Selection.Column if you want row number and column number of a cell dim x1,x2 as variant x1=range("ab10").Row x2=range("ab10").Colum -- anilsolipura ----------------------------------------------------------------------- anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627 View this thread: http://www.excelforum.com/showthread.php?threadid=38006 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting the row/column number
That is great. Thank -- micha ----------------------------------------------------------------------- michal's Profile: http://www.excelforum.com/member.php...fo&userid=2440 View this thread: http://www.excelforum.com/showthread.php?threadid=38006 |
| 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
