View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Object required error

But that is in the commandbutton sub, not the function, hence my point.

Bob


"Tom Ogilvy" wrote in message
...
For Each Cell In rngJ
Call mylabour
Next Cell

For Each Cell In rngK
Call mylabour
Next Cell

For Each Cell In rngL

--
Regards,
Tom Ogilvy


"Bob Phillips" wrote in message
...

"Tom Ogilvy" wrote in message
...

It doesn't appear to have arguments that aren't used as designed ....


rngJ, rngK, rngL? Where are they used in the function?