Forum Discussion
Sumit_Bhokare
May 25, 2022Brass Contributor
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...
NikolinoDE
May 25, 2022Platinum Contributor
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.
I know I don't know anything (Socrates)