Can't select range. Why the error?

  • Thread starter Thread starter agentsmith83
  • Start date Start date
A

agentsmith83

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.
 
Range expects an address, not a range object. Try this...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Copy columns and paste with blank column between 5
UnSelect the copied to range after copy... 4
How to get a macro to run on all files in a folder and save each one? 0
File Name changes with dates and Deleting Rows of Zeros 0
Sorting in Ascending Order 2
Ron de Bruin - Merge cells from all worksheets 0
ERROR 400 on identical codes different range 8

Back
Top