2 windows for workbook - Macro switches worksheet

  • Thread starter Thread starter Hari
  • Start date Start date
H

Hari

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
 
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
==================================
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 paste method of worksheet class failed 3
Macro to run on hidden sheet 4
Opening a Workbook with a Macro 4
Copy & paste macro for multiple worksheets 8
question about syntax in a simple macro... 3
Updating macros with copied worksheet information 3
Macro to populate same cell on multiple worksheets 1
Macro to Copy / paste from 1 workbook to another 6

Back
Top