Thread: Can't select range. Why the error?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
agentsmith83 agentsmith83 is offline
external usenet poster
  
Posts: 1
Default Can't select range. Why the error?

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

Reply With QuoteReply With Quote