Aug 12 2022 06:48 AM
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 can then just paste into a document as needed.
I tried to record a macro but it does not record me choosing "copy as picture>as shown when printed"
Anyone can help please?
Aug 12 2022 10:33 AM
SolutionHere 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
I know I don't know anything (Socrates)
Aug 12 2022 10:25 PM
Thanks so much for the help, i was able to tweak that to get it to work.
Much appreciated
Aug 13 2022 12:16 AM
Aug 12 2022 10:33 AM
SolutionHere 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
I know I don't know anything (Socrates)