VBA - modules -vs- sheet
Posted by Jason Davis on October 20, 2001 11:23 AM
When entering code in a module:
The code selects the raw worksheet and moves the focus or selection to range a1.
Why does this not work if you are on entering code in a "sheet"?
Is it because "sheet" only applies to the worksheet you are on? Or is there another format to select a different worksheet and move the focus to a cell?
I can change the value of any cell on another worksheet but not move the focus.