Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    I have a spreadsheet from a client that seems to have the same hyperlink in each cell. I can remove them one by one either manually or with code but this loses their other formatting in most cases.

    Any ideas as to how to remove the hyperlinks but retain the other formatting?.

    An extract of the sheet is attached.
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    1. Add a second sheet to the book.
    2. Select the entire sheet of Sheet 1
    3. Copy it
    4. On the second sheet do:
    5. Paste Special... Formats [ok] out
    6. Paste Special... Values [ok] out


    Or
    1. Add a second sheet to the book.
    2. Select the entire sheet of Sheet 1
    3. Copy it
    4. On the second sheet do:
    5. Paste Special... Formats [ok] out
    6. Run your macro on sheet 1
    7. Copy all of sheet 2
    8. Back on Sheet 1, Do a Paste Special... Formats [ok] out
    9. Delete sheet 2

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    Absolutely brilliant - many thanks.

Posting Permissions

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