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: Zane Thompson   on Jan 09

After tinkering with
the Cells(30,10).Select, I have found that I can get it to work if I
define it a Activesheet.Cells(30,10).Select. This could be a solution
- It is also hanging when I attempt to select  ranges using
"Range(Cells(1,1),Cells(2,2)).Select", for example. I left that
'problem' at work, and will have to pick it up tomorrow. I am thinking
I can probably mention the worksheet somehow in these types of
statements too and get this thing off the ground again (at least I
hope I can!).

Now that I think of it, this code in my test file was in a module, and
I tied it to a button when I brought it over into the actual file it
was to be used in. Would it make any difference if the code is running
from a command button on another worksheet, and as such, is tied to
that worksheet as opposed to being in a module tied to the workbook??

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: