| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check if a cell is part of a series of cells (not a neat ra
Hi All,
I want to find out if a changed cell was one of a number of cells. The cells i want to test for are B10,B15,B20,B25,B30 etc. upto B80. I can use the IF statement with a lot of ORs to check this but surely there is another, cleaner way to do this. Can anyone tell me how? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$10" OR Target.Address = "$B$15" OR Target.Address = "$B$20" OR ....... THEN code to execute END IF end sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use worksheet name in one cell as part of reference in other cells | Excel Discussion (Misc queries) | |||
| How to use number in some cell as a part of other cells reference? | Excel Worksheet Functions | |||
| How to check if a cell is part of a series of cells (not a neat ra | Excel Programming | |||
| Selecting part of a series for a chart? | Charts and Charting in Excel | |||
| How do i check if the current cell is part of a range ? | Excel Programming | |||
Hybrid Mode
