| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can VBA read the row-col location of a selected cell?
I am trying to assign the row and column of a selected excel cell to a
variable name, then return from the VBA procedure to the cell directly below that cell...without much luck. Can anybody help? Thanks...James Hill |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can VBA read the row-col location of a selected cell?
Hi
selection.row and selection.column will give you the information you need Anyway, you can reach the cell below by writing the instruction below if you are on the activecell activecell.offset(1,0).select Regards "news.bcentral.com" a écrit dans le message de news: ... I am trying to assign the row and column of a selected excel cell to a variable name, then return from the VBA procedure to the cell directly below that cell...without much luck. Can anybody help? Thanks...James Hill |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can VBA read the row-col location of a selected cell?
try using the .offset property
Example: Dim Cell As Range Set Cell = ActiveCell.Offset(1, 0) "news.bcentral.com" wrote: I am trying to assign the row and column of a selected excel cell to a variable name, then return from the VBA procedure to the cell directly below that cell...without much luck. Can anybody help? Thanks...James Hill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to read value of a cell in a relative location | Excel Worksheet Functions | |||
| Open From Read-Only Location ? | Excel Discussion (Misc queries) | |||
| automatic offset cell location when there is a value in a selected cell. | Excel Worksheet Functions | |||
| how read value from last selected cell? It is possible? how get adress last selected cell? | New Users to Excel | |||
| Exporting Chart to the selected location | Excel Programming | |||
Linear Mode
