Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 windows for workbook - Macro switches worksheet
Hi,
I use a shortcut macro for doing paste special values of formulas from one series of cells to other and it works just fine. Sub PasteSpecialValues() ' ' PasteSpecialValues Macro ' Macro recorded 6/8/2006 by Hari Prasadh ' ' Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub Today, I had 2 windows of the same workbook open and when I was copying some formulas from one worksheet and pasting in another worksheet (different window of the same workbook) the first window's worksheet also changed to second window's worksheet. Why would this switch hapen? Regards, HP India |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 windows for workbook - Macro switches worksheet
Since the two windows are for the same workbook, you change one will
automatically change another. -- Best regards, --- Yongjun CHEN ================================== - - - - www.XLDataSoft.com - - - - Free Excel/VBA Tool & Training Material ================================== "Hari" wrote in message ups.com... Hi, I use a shortcut macro for doing paste special values of formulas from one series of cells to other and it works just fine. Sub PasteSpecialValues() ' ' PasteSpecialValues Macro ' Macro recorded 6/8/2006 by Hari Prasadh ' ' Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub Today, I had 2 windows of the same workbook open and when I was copying some formulas from one worksheet and pasting in another worksheet (different window of the same workbook) the first window's worksheet also changed to second window's worksheet. Why would this switch hapen? Regards, HP India |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet function vs macro | Excel Discussion (Misc queries) | |||
Macro wiping out worksheet | Excel Worksheet Functions | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
How do I get my personal macro worksheet to open whenever I open . | Excel Discussion (Misc queries) |