| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional select range
Hi there,
I have no VBA-knowledge whatshowever. I was wondering if the following would be possible: Say: In A2:A500 I have names filled in: Bob, Jen, Tom ,.... Can I select Cells in column H:K when "Jen" is in that row? eg. A10 = "Jen" select range H10:K10 A67 = "Jen" select range H67:K67 and every other "row-"range when my name appears in the first Column? (Would it be possible to match the range (A2:A500) with a name I give in in an Inputbox? SO that I do not have to change the name every time in the code itself?) Hm many questions... All help really appreciated!! Jen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| select range and put range address in variable | Excel Programming | |||
| Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
| Select Sheet then Select Range | Excel Programming | |||
![Jen[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
