how can i copy Hyperlink

[iamprabhakaram]

Dear all
this is datta form Hyderabad
i want to copy hyper link to other cell (form column A to Column C) how can i i have 10250 Rows to copy like this pls help on this.

[sidd.iths]

hi,

why don't you just copy and paste the required hyperlink in the required cell? if there is something else to be taken into account, please be more specific.

sid

[iamprabhakaram]

Dear
i have to split 10 letters word into 2+3+5 in different cells. i have 10256 rows data with me in column A, i want to split this data in B, C and D columns as i specified earlier i have hyperlink in column A, for B,C and D columns for these columns i want hyperlink like Column A

[sidd.iths]

hi,

can you upload a sample file..

[iamprabhakaram]

Pls find attached file i required to copy my Column A hyperlink to column B and C

[:) Sixthsense :)]

May be this...

In D1

Please Login or Register  to view this content.

Drag it down

[iamprabhakaram]

Dear Sixthsense
there is separate hyperlink for each and every row for sample i kept it same

[:) Sixthsense :)]

Assume that the hyperlink target is in G column and just refer it like the below

Please Login or Register  to view this content.

[iamprabhakaram]

Sorry to reply again and again
i will get files from my corporate which contain hyperlink i have to split this column A as two parts and i have to keep the hyperlink which i received from corporate and i don't know how to do that

1. can i separate hyperlink from Column A? or can i copy and paste only hyperlink to other cells

[:) Sixthsense :)]

Try the below code in standard module

Select the Hyperlink data before running the below code.

In the below change the "D" to your desired column.
Cells(i, "D").Value = hTxT

Please Login or Register  to view this content.

Refer the attached file for details.