Foo_Man_Chu
Board Regular
- Joined
- Jul 22, 2010
- Messages
- 79
I feel embarrassed about posting this one, but I'm at my wit's end. Here's my code:
This is the only line I really care about:
If you haven't guessed it by now, all I want to do is set the ActiveCell on the sheet. But for all that I do it sets the ActiveCell to D3.
Somebody please help.
Code:
Public Sub setactivecell()
Worksheets("Sheet1").Activate
Worksheets("Sheet1").Range("F1:H4").Select
Worksheets("Sheet1").Range("G3").Select
MsgBox (activecell.address)
End Sub
This is the only line I really care about:
Code:
Worksheets("Sheet1").Range("G3").Select
If you haven't guessed it by now, all I want to do is set the ActiveCell on the sheet. But for all that I do it sets the ActiveCell to D3.
Somebody please help.