Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Richard Torres   on Dec 21 In MS Office Category.

  
Question Answered By: Alejandro Smith   on Dec 21

I'm not sure what's causing it, but I can suggest a couple of things to try...

1. Comment out the line Application.CutCopyMode = False and see if it
runs as expected. I have seen other cases where this command caused problems
(you got from the macro  recorder, right?)

2. Tell Excel explicitly which workbook and worksheet to use, either by fully
qualifying the ranges:
ThisWorkbook.Sheets("Whatever").Range("D33:K34").Select
or by issuing commands to make sure the correct workbook and worksheet are
active:
ThisWorkbook.Activate
ThisWorkbook.Sheets("Whatever").Activate
before the range commands that are being misdirected.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Multiple File Calling Or get search suggestion and latest updates.


Tagged: