+ Reply to Thread
Results 1 to 4 of 4

Adding grid lines and line numbers in the report

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    882

    Adding grid lines and line numbers in the report

    Hi guys

    Please see the code below. It works fine but in the report that gets printed off, it doesn't display grid lines and line numbers . Can it be done?

    Please can anyone help me in this?

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Adding grid lines and line numbers in the report

    .PrintHeadings = True
    .PrintGridlines = True
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    882

    Re: Adding grid lines and line numbers in the report

    Thats doesn't work. Please can anyone help me in this?

    Many thanks

  4. #4
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    882

    Re: Adding grid lines and line numbers in the report

    Thanks nathansav. It actually worked. SO now the gridlines are appearing in the print report. Now I want to display row numbers (lines numbers) too in the report.

    How can this be done?

    Many thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Adding Legend next to lines in Line Chart?
    By johanna0507 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-06-2013, 09:53 AM
  2. Replies: 1
    Last Post: 02-26-2013, 05:56 PM
  3. Adding additional grid lines
    By mknispel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-12-2011, 05:49 AM
  4. adding numbers for multiple text lines
    By nylarising in forum Excel General
    Replies: 6
    Last Post: 11-01-2007, 01:50 PM
  5. Automatically adding Vertical lines after certain points in line graph
    By matthoffman33 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-06-2006, 09:50 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1