| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to know the column/row of a selected cell in vba?
How can i determine in VBA the rows OR column (not the address) of
selected cell? if the selected cell is J20, i want to have a separate value assigne for x_col = 10 and y_row = 20 thank you for the hel -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to know the column/row of a selected cell in vba?
One way:
x_col = ActiveCell.Column x_row = ActiveCell.Row In article , daryl wrote: How can i determine in VBA the rows OR column (not the address) of a selected cell? if the selected cell is J20, i want to have a separate value assigned for x_col = 10 and y_row = 20 thank you for the help --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to know the column/row of a selected cell in vba?
I have a question relating to the original post: How do you change
the active cell using VBA? In other words if the cellpointer is in G10, how can I move it to G11? JE McGimpsey wrote in message ... One way: x_col = ActiveCell.Column x_row = ActiveCell.Row In article , daryl wrote: How can i determine in VBA the rows OR column (not the address) of a selected cell? if the selected cell is J20, i want to have a separate value assigned for x_col = 10 and y_row = 20 thank you for the help --- Message posted from http://www.ExcelForum.com/ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to know the column/row of a selected cell in vba?
One way:
Range("G11").Activate another: ActiveCell.Offset(1, 0). Activate A third: ActiveCell(2, 1).Activate In article , (Chris) wrote: I have a question relating to the original post: How do you change the active cell using VBA? In other words if the cellpointer is in G10, how can I move it to G11? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to know the column/row of a selected cell in vba?
x_col = Selection.cells(1).colum
y_row = Selection.cells(1).ro ----- daryl wrote: ---- How can i determine in VBA the rows OR column (not the address) of selected cell if the selected cell is J20, i want to have a separate value assigne for x_col = 10 and y_row = 2 thank you for the hel -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell or column highlights when other cell is selected | Excel Worksheet Functions | |||
| In VBA, How to Refer to Cell In Specific Column But Selected Rows? | Excel Discussion (Misc queries) | |||
| Add-in that highlight row/column of selected cell for easy viewing | Excel Discussion (Misc queries) | |||
| getting value 1 column to right of cell selected in pulldown | Excel Worksheet Functions | |||
| How to highlight row and column of the selected cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
