Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an worksheet with a Case structure for performing centain events is a
certain cell is selected: Select Case Target.Address Case "$B$4" If ....Then....End If End Select So, now I would like to increment to, lets say to cell B5. Is there a way can set up the following, unfortunately it did not work for me so I assumed it was not possibe or better yet I was doing something wrong?: Instead of Case "$B$4" can I use Case "$i$j" to loop through various cells? Thank you. D. Parker |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
reference cells when looping | Excel Discussion (Misc queries) | |||
how do i prevent continued highlighting cells when cursor moves? | New Users to Excel | |||
Looping on Cells with $x$y | Excel Programming | |||
Looping through Cells | Excel Programming | |||
Looping through a range of cells | Excel Programming |