Webhosting in Pakistan
Results 1 to 3 of 3

Thread: Ms excel help

  1. #1
    Hafeez194's Avatar
    Hafeez194 is offline Senior Member+
    Last Online
    29th October 2017 @ 09:41 AM
    Join Date
    14 Aug 2010
    Age
    38
    Gender
    Male
    Posts
    101
    Threads
    32
    Credits
    0
    Thanked: 1

    Default Ms excel help

    Webhosting in Pakistan
    Sir, mn Ms excel mn first page ko chor kr page number lagana chata hon. Plz help

  2. #2
    Hafeez194's Avatar
    Hafeez194 is offline Senior Member+
    Last Online
    29th October 2017 @ 09:41 AM
    Join Date
    14 Aug 2010
    Age
    38
    Gender
    Male
    Posts
    101
    Threads
    32
    Credits
    0
    Thanked: 1

    Default

    Still waiting please.

  3. #3
    syar is offline Advance Member
    Last Online
    10th September 2019 @ 08:47 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    42
    Gender
    Male
    Posts
    835
    Threads
    9
    Credits
    244
    Thanked
    340

    Default

    Webhosting in Pakistan
    salam::

    There is now built in way to this in excel or word but May be try with this

    1. Set your print Area.
    2. Alt+F11--->Insert Module (Copy This code)
    Code:
      Private Sub Workbook_BeforePrint(Cancel As Boolean)
            Dim wsSheet As Worksheet
            Dim sFooter As String
            Cancel = False
            Application.EnableEvents = False
            For Each wsSheet In ActiveWindow.SelectedSheets
                With wsSheet
                    sFooter = .PageSetup.LeftFooter
                    .PageSetup.LeftFooter = ""
                    .PrintOut From:=1, To:=1
                    .PageSetup.LeftFooter = sFooter
                    .PrintOut From:=2
                End With
            Next wsSheet
            Application.EnableEvents = True
        End Sub
    3. Run the Macro

    regards

Similar Threads

  1. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  2. MS EXCEL - Al-Quran in Excel
    By Mubashir Aziz in forum General Discussion
    Replies: 45
    Last Post: 16th March 2015, 08:59 PM
  3. Not Working Zaara's Excel Tutorial In Pdf & 300 Excel Tips
    By iftikhar01 in forum General Discussion
    Replies: 94
    Last Post: 14th May 2012, 04:28 PM
  4. Need Help in excel
    By nsm1870 in forum Solved Problems (IT)
    Replies: 4
    Last Post: 16th March 2010, 11:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •