I need to copy the Hyper link as well as the text in the followi

Closed
ryraum Posts 1 Registration date Thursday February 18, 2016 Status Member Last seen February 18, 2016 - Feb 18, 2016 at 05:11 AM
Computertech Posts 3569 Registration date Friday February 6, 2015 Status Moderator Last seen July 18, 2016 - Feb 18, 2016 at 05:42 AM
I am new to VBA, This code looks in one sheet and pastes it in a new sheet, but does not copy Hyper link, can this be done.


Range(wsO.Cells(1, 1), wsO.Cells(1, 9)).Value = Range(ws1.Cells(1, 1), ws1.Cells(2, 9)).Value
Range(wsO.Cells(1, 10), wsO.Cells(1, 10 + (endcol - startcol))).Value = Range(ws1.Cells(1, startcol), ws1.Cells(1, endcol)).Value
Related:

1 response

Computertech Posts 3569 Registration date Friday February 6, 2015 Status Moderator Last seen July 18, 2016 892
Feb 18, 2016 at 05:42 AM
Hello,

To provide help, regarding this formula's is not easy one, no body spent time and run the formula's on their own pc and provide help to others, but here in CCM there are some volunteers who provide help in taking time to workout with the formulas you asking for, by executing on their own pc.

Therefore during asking for help you should be polite and responsible of giving respect. Please add Hello (appreciate, grateful, etc.) in the Beginning of your query and ending it by Thank you. So that it is a big thing you did for whom you help.

Hope you understand.

Generally according to our Charter we can't answer the questions who didn't follow our politeness charter. Instead we close that topic.

Please, copy, modify and repost your message respecting the politeness charter.

For CCM politeness charter please read this article:


https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

Thanks.
0