Pasting hyperlink from sheet A to Sheet B?
 

Does anyone know how to paste a hyperlink from sheet A cells(1,1) to
Sheet B cells(3,3) using VBA? The macro recorder apparently won't do
it for reasons unbeknownst to me.

Thanks,
Chet

Pasting hyperlink from sheet A to Sheet B?
 

Sub chet()
Set r1 = Sheets("Sheet A").Cells(1, 1)
Set r2 = Sheets("Sheet B").Cells(3, 3)
r1.Copy r2
End Sub


This wil take the hyperlink stored in Sheet A and copy it to Sheet B
--
Gary''s Student
gsnu200710


"Chet" wrote:

Does anyone know how to paste a hyperlink from sheet A cells(1,1) to
Sheet B cells(3,3) using VBA? The macro recorder apparently won't do
it for reasons unbeknownst to me.

Thanks,
Chet

Pasting hyperlink from sheet A to Sheet B?
 

Hi Gary's student,
Are you sure that will copy the hyperlink and not just the cell
values? Thx Chet :)

On Mar 13, 12:17 pm, Gary''s Student
wrote:
Sub chet()
Set r1 = Sheets("Sheet A").Cells(1, 1)
Set r2 = Sheets("Sheet B").Cells(3, 3)
r1.Copy r2
End Sub

This wil take the hyperlink stored in Sheet A and copy it to Sheet B
--
Gary''s Student
gsnu200710



"Chet" wrote:
Does anyone know how to paste a hyperlink from sheet A cells(1,1) to
Sheet B cells(3,3) using VBA? The macro recorder apparently won't do
it for reasons unbeknownst to me.

Thanks,
Chet- Hide quoted text -

- Show quoted text -

Pasting hyperlink from sheet A to Sheet B?
 

It did work.. !.. nice and simple.. i like it..!.. thx Chet


On Mar 13, 12:17 pm, Gary''s Student
wrote:
Sub chet()
Set r1 = Sheets("Sheet A").Cells(1, 1)
Set r2 = Sheets("Sheet B").Cells(3, 3)
r1.Copy r2
End Sub

This wil take the hyperlink stored in Sheet A and copy it to Sheet B
--
Gary''s Student
gsnu200710



"Chet" wrote:
Does anyone know how to paste a hyperlink from sheet A cells(1,1) to
Sheet B cells(3,3) using VBA? The macro recorder apparently won't do
it for reasons unbeknownst to me.

Thanks,
Chet- Hide quoted text -

- Show quoted text -

Pasting hyperlink from sheet A to Sheet B?
 

I just tested it. Put http://www.cnn.com in A1

it copied EVERYTHING:

1. cell contents
2. cell formatting
3. cell hyperlink
4. cell comments

Just give it a try
--
Gary''s Student
gsnu200710


"Chet" wrote:

Hi Gary's student,
Are you sure that will copy the hyperlink and not just the cell
values? Thx Chet :)

On Mar 13, 12:17 pm, Gary''s Student
wrote:
Sub chet()
Set r1 = Sheets("Sheet A").Cells(1, 1)
Set r2 = Sheets("Sheet B").Cells(3, 3)
r1.Copy r2
End Sub

This wil take the hyperlink stored in Sheet A and copy it to Sheet B
--
Gary''s Student
gsnu200710



"Chet" wrote:
Does anyone know how to paste a hyperlink from sheet A cells(1,1) to
Sheet B cells(3,3) using VBA? The macro recorder apparently won't do
it for reasons unbeknownst to me.

Thanks,
Chet- Hide quoted text -

- Show quoted text -