Hmm, it just doesn't seem to like it when I try and select one or more
columns.


Code:
--------------------
Set rng = Intersect(Range("J:R"), ActiveSheet.UsedRange)
--------------------


Is that definitely the right syntax?


--
m1ke
------------------------------------------------------------------------
m1ke's Profile: http://www.excelforum.com/member.php...o&userid=30519
View this thread: http://www.excelforum.com/showthread...hreadid=501697