I'm trying to paste text into some cells (in column B) and then merge
with cells C through I. The paste command works, but I get an error on
the select line. I don't know why I can't select that range.


With ActiveSheet
..Range("B35").PasteSpecial
..Range("C35", Range("I35").End(xlDown)).Select
..Selection.ClearContents
..Selection.Merge (True)
End With

Thanks for any help.


--
agentsmith83
------------------------------------------------------------------------
agentsmith83's Profile: http://www.excelforum.com/member.php...o&userid=33600
View this thread: http://www.excelforum.com/showthread...hreadid=533770