Forum Discussion

Copper Contributor

Aug 12, 2022

Solved

Help to automate a process

Hi, Still learning with excel but I am hoping this is not too hard. I have a spreadsheet named PDF. I want a macro to select range A1 to I26 copy as picture - as shown when printed I ...

excel

Macros and VBA

NikolinoDE
Aug 12, 2022
Dave_StewartUK
Here is a small macro, untested..hope it will help you.
Public Sub PicAreaCopy() Sheet1.Range("A1:H15").CopyPicture Appearance:=xlScreen, Format:=xlPicture With Sheet2 .Paste .Range("A1") End With End Sub

NikolinoDE
I know I don't know anything (Socrates)

NikolinoDE

Gold Contributor

Aug 12, 2022

Dave_StewartUK

Here is a small macro, untested..hope it will help you.

Public Sub PicAreaCopy()
Sheet1.Range("A1:H15").CopyPicture Appearance:=xlScreen, Format:=xlPicture
With Sheet2
.Paste .Range("A1")
End With
End Sub

NikolinoDE

I know I don't know anything (Socrates)

Dave_StewartUK

Copper Contributor

Aug 13, 2022

NikolinoDE

Thanks so much for the help, i was able to tweak that to get it to work.

Much appreciated

NikolinoDE
Gold Contributor
Aug 13, 2022
I am glad that I could help

I wish you continued success with Excel