Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specify which sheet to paste to
I have recorded a simple macro and want to specify that it always pastes into
the sheet named 'Link' here is my current code Sub McrUpdateLink() ' ' McrUpdateLink Macro ' Macro recorded 06/15/2006 ' ' Cells.Select Selection.Copy ActiveSheet.Previous.Select Cells.Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Application.CutCopyMode = False Range("A2").Select ActiveSheet.Next.Select Range("H2").Select End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specify which sheet to paste to
I have changed a couple of lines below, not tried them but give it a go it should work Regards, Simon Sub McrUpdateLink() ' ' McrUpdateLink Macro ' Macro recorded 06/15/2006 Cells.Select Selection.Copy ActiveSheet.Previous.Select Cells.Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Application.CutCopyMode = False Range("A2").Select Sheets("Link").Select 'I think this is the line you need Range("H2").Select ActiveSheet.paste 'and this one to paste in to H2 on the sheet named Link End Sub -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=552359 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to automatically paste cells from one sheet to another sheet? | Excel Discussion (Misc queries) | |||
Alternate Row Select in Sheet 1 then Paste to Sheet 2 | Excel Worksheet Functions | |||
Copy from one Sheet and paste on another sheet based on condition | Excel Discussion (Misc queries) | |||
Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
automatic copy and paste from sheet to sheet in a workbook | Excel Programming |