Re: Select Sheet then Select Range

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Gee (anonymous_at_discussions.microsoft.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 14:10:57 -0700

Thanks, Trevor...worked perfectly!
Frank...that was useful, but I needed it to actually go to
the cell...though I'm going to keep that bit of
code 'cause I'm going to need it on another
project...you're psychic!
Gee
>-----Original Message-----
>Gee
>
>not sure quite why this works, but try it anyway:
>
>Sheets("SOURCE 1").Select
>With Sheets("SOURCE 1")
> .Range("H77").Select
>End With
>
>Regards
>
>Trevor
>
>
>"Gee" <anonymous@discussions.microsoft.com> wrote in
message
>news:13cdf01c4442b$7d420e20$a501280a@phx.gbl...
>> I'm having trouble with a button I created. When
clicked
>> it's supposed to go to *** "SOURCE 1" and then to Cell
>> H77. I keep getting the message "Select Method of Range
>> Class has Failed"
>>
>> Private Sub CommandButton31_Click()
>> Sheets("SOURCE 1").Select
>> Range("H77").Select
>> End Sub
>>
>> Any ideas what I'm doing wrong?
>>
>> Thank you for any help you can give me,
>> Gee
>
>
>.
>

Quantcast