I guess it depends on whose code you are using.

But look at

..resize(1,5)

--
Regards,
Tom Ogilvy


wesandem wrote in message
...
Thanks for the help guys - looks like it's working perfectly now. One
more thing I should have asked earlier - what would I change if I want
this action to apply to not just the adjacent cell but to the next five
cells?


---
Message posted from http://www.ExcelForum.com/