| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving relative
Say that you have an excel sheet with with columns A to K and 1000 rows
in it. I have a search function that activates a cell, when the result of the search is found. For example Cell J243. Now I want it to automaticly activate Cell A243. How do I make it go to column A in a row, no matter from what column it originated at the end of the search. Examples: J243 -- A243 C852 -- A852 Thx from the n00b Rune daub --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Moving relative
Rune daub,
range("A" & activecell.Row).Activate John "Rune_Daub " wrote in message ... Say that you have an excel sheet with with columns A to K and 1000 rows in it. I have a search function that activates a cell, when the result of the search is found. For example Cell J243. Now I want it to automaticly activate Cell A243. How do I make it go to column A in a row, no matter from what column it originated at the end of the search. Examples: J243 -- A243 C852 -- A852 Thx from the n00b Rune daub --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving text around cells without moving boarder lines | Excel Discussion (Misc queries) | |||
| Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
| What relative row I'm in? | Excel Worksheet Functions | |||
| Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
| How to pick one or more items out of a list, moving to new list, moving up or down. (form) | Excel Discussion (Misc queries) | |||
![Rune_Daub[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
