Copying Formatting Without Selecting
 

Hello.

I would like to copy formatting from one Range to another, without selecting
it. (A PasteSpecial Format, but without actually selecting the Range.)

Can this be done? Any help would be appreciated.

Thanks.

Dan