Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find out my row number
I need to find out the row number of the cell selected.
Here is a piece of code I am working with. Cells(65536, j).Select Selection.End(xlUp).Select I need to find out my position. Any help is appreciated. Rgds, -Neil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find out my row number
Hi
one way: msgbox activecell.address or msgbox activecell.row -- Regards Frank Kabel Frankfurt, Germany Neil Bhandar wrote: I need to find out the row number of the cell selected. Here is a piece of code I am working with. Cells(65536, j).Select Selection.End(xlUp).Select I need to find out my position. Any help is appreciated. Rgds, -Neil |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find out my row number
Neil,
Selection.Row will return the row number of the selected cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Neil Bhandar" wrote in message ... I need to find out the row number of the cell selected. Here is a piece of code I am working with. Cells(65536, j).Select Selection.End(xlUp).Select I need to find out my position. Any help is appreciated. Rgds, -Neil |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find out my row number
Here's a small routine to demonstrate
Sub Cell_Loc() Ro = ActiveCell.Row Co = ActiveCell.Column CellLoc = ActiveCell.Address MsgBox ("Row " & Ro & ", " & "Column " & Co & ", " & "Cell Location " & CellLoc) End Sub -----Original Message----- I need to find out the row number of the cell selected. Here is a piece of code I am working with. Cells(65536, j).Select Selection.End(xlUp).Select I need to find out my position. Any help is appreciated. Rgds, -Neil . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find number of weekdays and wekend days given a total number of da | Excel Discussion (Misc queries) | |||
Find previous number and find next number in column | Excel Discussion (Misc queries) | |||
Need Cells.find to find first number in a row which is 8000 | Excel Discussion (Misc queries) | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
How do I find the total number of the same number/letter in a row | Excel Discussion (Misc queries) |