Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Harley Evans   on Jan 11 In MS Office Category.

  
Question Answered By: Abasi Massri   on Jan 11

Have you tried recording a macro that does this and see what the differences
are?
I'm sure you've got lots of code  that you didn't include here.
Like: I don't see where you've saved wkbook, or RDate.
Also, if you're using Rows(1,1).delete
you don't need to do Rows(1,1).select...
Because, Rows(1,1).Delete is actually a combination of two commands:
Rows(1,1).Select
Selection.Delete
I'd start with recording the macro, and see if the recorded macro gives the same
result.
If it does not, compare the two and see how they differ...

Share: 

 

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

 
Didn't find what you were looking for? Find more on Activesheet.Paste method gives error Or get search suggestion and latest updates.


Tagged: