Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copy HYPERLINKS
I have about 200 entries in col a
Some of these entries are hyperlinks to other locations I would like a macro to copy ONLY the hyperlinks from Col a to Col b Currently the hyperlinked items are interspaced over the entire col a, I would like to have all the hyperlinks moved to Col B one under the other with no spaces. Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copy HYPERLINKS
Are they =HYPERLINK functions or Inserted hyperlinks??
-- Gary''s Student - gsnu200750 "pcor" wrote: I have about 200 entries in col a Some of these entries are hyperlinks to other locations I would like a macro to copy ONLY the hyperlinks from Col a to Col b Currently the hyperlinked items are interspaced over the entire col a, I would like to have all the hyperlinks moved to Col B one under the other with no spaces. Thanks |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copy HYPERLINKS
Try:
Sub marine() Range("A:A").Copy Range("B1") n = Cells(Rows.Count, "B").End(xlUp).Row For m = n To 1 Step -1 If Cells(m, "B").Hyperlinks.Count = 0 Then Cells(m, "B").Delete Shift:=xlUp End If Next End Sub -- Gary''s Student - gsnu200750 "pcor" wrote: I have about 200 entries in col a Some of these entries are hyperlinks to other locations I would like a macro to copy ONLY the hyperlinks from Col a to Col b Currently the hyperlinked items are interspaced over the entire col a, I would like to have all the hyperlinks moved to Col B one under the other with no spaces. Thanks |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copy HYPERLINKS
I did TRY and it worked the VERY BEST. Thanks a great deal
"Gary''s Student" wrote: Try: Sub marine() Range("A:A").Copy Range("B1") n = Cells(Rows.Count, "B").End(xlUp).Row For m = n To 1 Step -1 If Cells(m, "B").Hyperlinks.Count = 0 Then Cells(m, "B").Delete Shift:=xlUp End If Next End Sub -- Gary''s Student - gsnu200750 "pcor" wrote: I have about 200 entries in col a Some of these entries are hyperlinks to other locations I would like a macro to copy ONLY the hyperlinks from Col a to Col b Currently the hyperlinked items are interspaced over the entire col a, I would like to have all the hyperlinks moved to Col B one under the other with no spaces. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheet with internal hyperlinks | Excel Worksheet Functions | |||
Copy/Paste hyperlinks between workbooks | Excel Discussion (Misc queries) | |||
Why does excel change my hyperlinks when I copy a worksheet? | New Users to Excel | |||
Copy & paste from Word to Excel with hyperlinks | Excel Discussion (Misc queries) | |||
how do you copy hyperlinks from one worksheet to another | Excel Worksheet Functions |