Simple Copy Range Error

**Jiptastic** · 02-21-2013, 12:56 PM

What's the matter with this syntax? Can't I paste a single cell into multiple cells? This errors on "Application-Defined or Object-Defined Error"

Please Login or Register  to view this content.

**romperstomper** · 02-21-2013, 01:04 PM

You haven't properly qualified all the relevant Cells properties:

Please Login or Register  to view this content.

**Norie** · 02-21-2013, 01:06 PM

Either fully qualify Cells or try this.

Please Login or Register  to view this content.

**Jiptastic** · 02-21-2013, 01:11 PM

Romperstomper, I am pasting from the activesheet to another, so this solution doesn't work. Do you really need that many periods before cells and before Range?

**JOHN H. DAVIS** · 02-21-2013, 01:13 PM

Maybe try:

Please Login or Register  to view this content.

**Norie** · 02-21-2013, 01:16 PM

Jiptastic

romperstomper's code will work, it is copying from the active sheet to 'Pasted Zip Codes'.

**romperstomper** · 02-21-2013, 01:17 PM

@Jiptastic
It does work and does exactly what you described. If it doesn't work for you, I have to assume you copied something wrongly (or added an extra full stop in front of the first Cells call)