Copy but avoiding selecting

**MCCCLXXXV** · 10-18-2007, 10:58 AM

Is there any way to write this code so that it doenst have to select the sheets and ranges before operating?

Please Login or Register  to view this content.

thanks

**VBA Noob** · 10-18-2007, 11:08 AM

Maybe

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

VBA Noob

**MCCCLXXXV** · 10-18-2007, 11:40 AM

wow. thanks top one worked perfectly. i had tried that, but without the .value after each object

thanks again

**VBA Noob** · 10-18-2007, 11:43 AM

Glad it helped

VBA Noob