Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    London, Gtr London, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    copy and paste sheet name (XP 2003)

    I want to add the sheet name to each row of the worksheet. I can copy the sheet name as part of a rename operation, and then escape, select my target cell, and paste. I would like to automate this, there are many sheets in the workbook, but recording a macro dosent seem to work. Even if I could automate enough to get the sheet name into cell A1, then I could fill down easily. Is there a formula/macro to do this? TIA

    Frank

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: copy and paste sheet name (XP 2003)

    See <post:=620,997>post 620,997</post:>.

Posting Permissions

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