+ Reply to Thread
Results 1 to 6 of 6

print comments with cell label or name

  1. #1
    Mohammad
    Guest

    print comments with cell label or name

    How can I print comments, at page end, with cell label or given name instead
    of standard cell name like A1, C4 etc..?
    Thank you

  2. #2
    Jason Morin
    Guest

    RE: print comments with cell label or name

    I'm sure you'll find some code here to meet your needs:

    http://www.contextures.com/xlcomments03.html#copy

    HTH
    Jason
    Atlanta, GA



    "Mohammad" wrote:

    > How can I print comments, at page end, with cell label or given name instead
    > of standard cell name like A1, C4 etc..?
    > Thank you


  3. #3
    Mohammad
    Guest

    RE: print comments with cell label or name

    Jason,

    Thank you for the link. It is very helpfull. However it did not answer my
    question. I'll contact the owner of the link. Thanks again.

    "Jason Morin" wrote:

    > I'm sure you'll find some code here to meet your needs:
    >
    > http://www.contextures.com/xlcomments03.html#copy
    >
    > HTH
    > Jason
    > Atlanta, GA
    >
    >
    >
    > "Mohammad" wrote:
    >
    > > How can I print comments, at page end, with cell label or given name instead
    > > of standard cell name like A1, C4 etc..?
    > > Thank you


  4. #4
    Debra Dalgleish
    Guest

    Re: print comments with cell label or name

    You can't change the built-in comment printing feature. Either use
    programming, as shown at the link Jason provided, or go with the default
    format.

    Mohammad wrote:
    > Jason,
    >
    > Thank you for the link. It is very helpfull. However it did not answer my
    > question. I'll contact the owner of the link. Thanks again.
    >
    > "Jason Morin" wrote:
    >
    >
    >>I'm sure you'll find some code here to meet your needs:
    >>
    >>http://www.contextures.com/xlcomments03.html#copy
    >>
    >>HTH
    >>Jason
    >>Atlanta, GA
    >>
    >>
    >>
    >>"Mohammad" wrote:
    >>
    >>
    >>>How can I print comments, at page end, with cell label or given name instead
    >>>of standard cell name like A1, C4 etc..?
    >>>Thank you

    >>



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


  5. #5
    David McRitchie
    Guest

    Re: print comments with cell label or name

    are you sure you looked at correct article::
    http://www.contextures.com/xlcomment...ml#CopyToSheet
    If it doesn't do what you want then indicate what you really wanted
    or want to change. Perhaps you want also the label at the top of
    the column that the cell is in and the label to the left of the row that
    the cell is in as well. (untested)
    .Cells(i, 5).Value = mycell.offset(-mycell.row+1).Value .Cells(i, 5).Value = mycell.offset(-mycell.column+1).Value"Mohammad"
    <Mohammad@discussions.microsoft.com> wrote ...> Jason,
    >
    > Thank you for the link. It is very helpfull. However it did not answer my
    > question. I'll contact the owner of the link. Thanks again.
    >
    > "Jason Morin" wrote:
    >
    > > I'm sure you'll find some code here to meet your needs:
    > >
    > > http://www.contextures.com/xlcomments03.html#copy
    > >
    > > HTH
    > > Jason
    > > Atlanta, GA
    > >
    > >
    > >
    > > "Mohammad" wrote:
    > >
    > > > How can I print comments, at page end, with cell label or given name instead
    > > > of standard cell name like A1, C4 etc..?
    > > > Thank you




  6. #6
    Mohammad
    Guest

    Re: print comments with cell label or name

    David, CopyToSheet will help. I'll use it. I think I'll have to create
    comment sheet and print it separatly. Thank you all.

    "David McRitchie" wrote:

    > are you sure you looked at correct article::
    > http://www.contextures.com/xlcomment...ml#CopyToSheet
    > If it doesn't do what you want then indicate what you really wanted
    > or want to change. Perhaps you want also the label at the top of
    > the column that the cell is in and the label to the left of the row that
    > the cell is in as well. (untested)
    > .Cells(i, 5).Value = mycell.offset(-mycell.row+1).Value .Cells(i, 5).Value = mycell.offset(-mycell.column+1).Value"Mohammad"
    > <Mohammad@discussions.microsoft.com> wrote ...> Jason,
    > >
    > > Thank you for the link. It is very helpfull. However it did not answer my
    > > question. I'll contact the owner of the link. Thanks again.
    > >
    > > "Jason Morin" wrote:
    > >
    > > > I'm sure you'll find some code here to meet your needs:
    > > >
    > > > http://www.contextures.com/xlcomments03.html#copy
    > > >
    > > > HTH
    > > > Jason
    > > > Atlanta, GA
    > > >
    > > >
    > > >
    > > > "Mohammad" wrote:
    > > >
    > > > > How can I print comments, at page end, with cell label or given name instead
    > > > > of standard cell name like A1, C4 etc..?
    > > > > Thank you

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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