| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match a cell in a range to a value from another sheet and select r
I have 2 worksheets A & B. I have a variable cell in sheet A which I change
from 1 - 26. I have a permanent range in a column on sheet B of 1 - 26. I need a macro that will select the row in sheet B that matches the variable in Sheet A. If I type 5 in Sheet A, the ROW with 5 on sheet B is selected. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking sheet - Formula Match Exact or select next row and cell | Excel Discussion (Misc queries) | |||
| Can't Select Range off sheet from inputbox | Excel Discussion (Misc queries) | |||
| select a range, copy it to a new sheet | Excel Discussion (Misc queries) | |||
| Can select range of sheet | Excel Programming | |||
| Select Sheet then Select Range | Excel Programming | |||
Threaded Mode
