I am preparing a report using macro . I want to copy that one page report to
a new file as a picture link.

Can some one help me in writing a macro to copy - say range A1 : T50 - from
one file and paste it to a new file as picture link?

Thanks