Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Grant Young   on Jan 09 In MS Office Category.

  
Question Answered By: Joseph Evans   on Jan 09

I've had something similar happen.
I have no idea if my 'solution' actually fixed it or if it
was just a coincidence.
But it "seemed" that even though I "selected" the worksheet.
the "Active" sheet remained the same.
i added the line: worksheets("Maria").activate (for example)
after the Worksheets("Maria").select statement, and it seems to have fixed it!

Like I said, it may not even be the problem...
give it a shot..

Share: 

 

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

 
Didn't find what you were looking for? Find more on Select Method or Range Class failed Or get search suggestion and latest updates.


Tagged: