#1
|
|||
|
|||
Select row based on cell value
Hello MSO Forums! First time poster here (Just created an account just now). My question is this. Is there a way to select a row based on the value in a cell?
Cell A1's value is 105 So I want to have row 105 selected Is there a way to do this? I'd like resources and/or hints instead of the complete answer. Thanks in advance! |
#2
|
|||
|
|||
I'd suggest you look into the Worksheet_Change event to execute something like
rows(target.value).select |
Tags |
excel programming |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cell color based on cell value as compared to another cell va | COgreywolf | Excel | 9 | 09-25-2018 12:28 PM |
Macro to select cell based on formula | mreynolds1775 | Excel Programming | 4 | 09-22-2017 12:13 PM |
Select value from table based on two criteria | gebobs | Excel | 4 | 07-21-2016 08:26 AM |
Cell A1 Select car maker = Cell B1 shows menu for car models | jaywizz1 | Excel | 1 | 03-11-2016 05:09 PM |
Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |