You have to dim crpRange first as a range. Then your code should
work as written.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"TechWrangler"
wrote
in message
news:TechWrangler.27jtbo_1147191904.4721@excelforu m-nospam.com...

Thanks for the quick help that was the problem. New question,
do you see
what is wrong with this statement:

Set crpRange = Range("CustomerRelatedProcess")

Where CustomerRelatedProcess is a Named range. Maybe the
quotes, maybe
I have to Dim it first?


--
TechWrangler


------------------------------------------------------------------------
TechWrangler's Profile:
http://www.excelforum.com/member.php...o&userid=34244
View this thread:
http://www.excelforum.com/showthread...hreadid=540331