Macro to past link from Sheet 1 to Sheet 2 
Author Message
 Macro to past link from Sheet 1 to Sheet 2

Hi, I am trying to write a macro that will paste the link
from a cell on sheet one to a cell on sheet two.  I am
getting an error that says "Object doesn't support this
action." It is referring to the line of code that
specifies Range "R14"

this is what I have written thus far.

Worksheets("Budget Setup--Billing Group 1").Range
("Q12").Copy
Worksheets("Project Cost Estimate(BG1)").Range
("R14").Paste Link = True
Worksheets("Budget Setup--Billing Group 1").Range
("Q12").Select
Application.CutCopyMode = False

Thank you.  



Mon, 15 Nov 2004 22:07:45 GMT  
 Macro to past link from Sheet 1 to Sheet 2
Worksheets("Budget Setup--Billing Group 1").Range("Q12").Copy
ThisWorkbook.Sheets("Project Cost Estimate(BG1)").Cells(14, 18).Select
ThisWorkbook.Sheets("Project Cost Estimate(BG1)").Paste
Worksheets("Budget Setup--Billing Group 1").Activate
Range("Q12").Select
Application.CutCopyMode = False


Quote:
> Hi, I am trying to write a macro that will paste the link
> from a cell on sheet one to a cell on sheet two.  I am
> getting an error that says "Object doesn't support this
> action." It is referring to the line of code that
> specifies Range "R14"

> this is what I have written thus far.

> Worksheets("Budget Setup--Billing Group 1").Range
> ("Q12").Copy
> Worksheets("Project Cost Estimate(BG1)").Range
> ("R14").Paste Link = True
> Worksheets("Budget Setup--Billing Group 1").Range
> ("Q12").Select
> Application.CutCopyMode = False

> Thank you.



Mon, 15 Nov 2004 22:57:31 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Linking info in one sheet to another sheet

2. VBA to link cell on one sheet to cell on another sheet

3. Linked sheets - Insert rows in all sheets?

4. Linking Sheet Tab Name to Cell in Current Sheet

5. Excel Linked Sheet/Embedded Sheet

6. column A in sheet A linked to all sheets in workbook

7. consolidate Sheet 1+ Sheet 2 = Sheet 3 based on some criteria

8. Macro to copy sheet, with chart, to new sheet

9. Relative macro sheet:sheet

10. Macro Loop to select sheet after sheet


 
Powered by phpBB® Forum Software © phpBB Group