Forum Discussion

Brass Contributor

May 25, 2022

How to remove non printable area from excel and save as file

Hi, I need one help to save existing file which have non printable area & I want to save as file without non printable area. I also have linking between non printable area to printable area so whil...

Test1.xlsx283 KB

Macros and VBA

NikolinoDE

Platinum Contributor

May 25, 2022

Sumit_Bhokare

File won't open probably corrupt or associated macros that I won't open.
Nevertheless, here is a macro to try out for yourself...not tested.

Sub MacroCopy()
Workbooks.Add
Windows("Filename_Source.xls").Activate
Sheets("sheet_name_source").Select
Sheets("TableName_Target").Copy Before:=Workbooks("Book1").Sheets(1)
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Windows("Filename_Source.xls ").Activate
end sub

Hope I could help you with these information.

NikolinoDE

I know I don't know anything (Socrates)