Posted to microsoft.public.excel.programming

external usenet poster

Posts: 7

Select Sheet then Select Range

I'm having trouble with a button I created. When clicked
it's supposed to go to sheet "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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't Select Range off sheet from inputbox	Jim May	Excel Discussion (Misc queries)	4	September 29th 07 08:26 PM
Select data to appear on 2nd sheet by date range...	Cbreze	Excel Discussion (Misc queries)	0	June 28th 07 12:10 AM
sheet protection - only selected range to be able to select/input data	Corey	Excel Worksheet Functions	7	February 13th 07 05:41 PM
select a range, copy it to a new sheet	Dave F	Excel Discussion (Misc queries)	1	September 22nd 06 08:06 PM
Automatically select range and copy to new sheet	Alistair[_2_]	Excel Programming	3	October 11th 03 04:33 AM

All times are GMT +1. The time now is 05:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us