Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
Use the fact that adding the key, if it is already there, creates an error On Error Resume Next 'maybe want a loop here? err.clear c.add 1, "dogs" if error.number<0 then temp = c.item("dogs")+1 c.remove "dogs" c.add temp, "dogs" end if 'next on error goto 0 Above is untested. I don't THINK the first add will actually do the add if an error is generated... Err.clear is required to catch the error each time. Err also exists as long as the application is open, so it is always a good idea to clear it if using error.number<0 regards Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array Question | Excel Discussion (Misc queries) | |||
array question | Excel Programming | |||
Array Question | Excel Programming | |||
Array question | Excel Programming | |||
array question | Excel Programming |