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

Range expects an address, not a range object. Try this...

..Range("C35", Range("I35").End(xlDown).address).Select
--
HTH...

Jim Thomlinson


"agentsmith83" wrote:


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