none
how to clear a page after printing RRS feed

  • Question

  • Hi,

    I have a format on excel sheet. I fill data there and have hard copy print out . I want One hidden copy of filled sheet with name as the date of data entered in cell H3 , ( belonging to period which was entered ) Another copy empty back as it was before entering data for printing for next use . All data entered to a master sheet on the same workbook . Please help. 

    regards,

    Monday, January 25, 2016 8:26 AM

Answers

  • Hi drsan,

    Based on your description, do you mean you want to print partial worksheet? If so, for manually operation, you could refer the link below:

    #Print a worksheet or workbook
    https://support.office.com/en-us/article/Print-a-worksheet-or-workbook-f4ad7962-b1d5-4eb9-a24f-0907f36c4b94

    For a VBA code, you could refer the recorded code, also, you could record the steps you manually operate.

    Sub Macro1()
    '
    ' Macro1 Macro
    '
    '
        Sheets(Array("Sheet2", "Sheet1")).Select
        Sheets("A-OfficeDevTake").Activate
        Selection.PrintOut Copies:=1, Collate:=True
        Application.WindowState = xlNormal
    End Sub

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Tuesday, January 26, 2016 2:06 AM