Dont't write

Range("A9:E9").Select

but

ActiveSheet.Range("A9:E9").Select

etc etc

Please quote the post you're replying to in your own posts - it's difficult
to know what you're replying to otherwise, and you're more likely to get
help if you do.
If you're posting through some kind of web interface (ugh) there's most
likely an option to include this.

Tim

--
Tim Williams
Palo Alto, CA


"solomon_monkey" wrote in message
ups.com...
Apologies for the very novice like comment but I don't know what you
are talking about. It sounds like it would solve my problems though.