| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto a specific Cell
Hi,
I have the row number of the activecell, and also the column number from a range via: Activecell.row range("myrange").column 'may be moved what I would like to do is goto that corresponding cell i.e. if the user is on row 40 and myrange is D then goto D40 Any help appreciated! Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Goto a specific Cell
If ? I understand your request
cells(activecell.row,"d").select -- Don Guillett SalesAid Software "Sanjay" wrote in message ... Hi, I have the row number of the activecell, and also the column number from a range via: Activecell.row range("myrange").column 'may be moved what I would like to do is goto that corresponding cell i.e. if the user is on row 40 and myrange is D then goto D40 Any help appreciated! Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Goto a specific Cell
Cells(activecell.row,myrange.column).Select
-- Regards, Tom Ogilvy "Sanjay" wrote: Hi, I have the row number of the activecell, and also the column number from a range via: Activecell.row range("myrange").column 'may be moved what I would like to do is goto that corresponding cell i.e. if the user is on row 40 and myrange is D then goto D40 Any help appreciated! Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to goto specific cell (todays date) | Excel Discussion (Misc queries) | |||
| Goto a specific cell in a macro | Excel Discussion (Misc queries) | |||
| Goto specific sheet and cell | Excel Programming | |||
| How do I goto a specific Record in my Database? | Excel Programming | |||
| Goto Specific Textbox in Userform | Excel Programming | |||
![Sanjay[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
