Your code appears to work fine but I would
like two slight modifications:

1. Instead of the macro stopping to copy and
paste-special values as soon as it meets a blank
range, I would like for it to continue with the
process *even* if the range it copies and pastes are
blank all the way down till the end of the sheets. The
reason is that sometimes blank ranges exist between
ranges with actual data to be copied.

2. Also, instead of the macro copying and
paste-special values, if I want it to just copy and
Link the ranges (i.e paste-special paste Link), how
would the code look like?

Thanks.
Jay Dean




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!