Posted to microsoft.public.excel.programming

Oldjay

external usenet poster

Posts: 337

Command button failure

Why does the following fail @ Range("D2").Select

Rum-time error '1004"
Application-defined or object-defined error

If I run the exact same code in a Macro it works fine

Private Sub CommandButton1_Click()

Workbooks.Add
ActiveWorkbook.SaveAs Filename:="TempData.xls"
Windows("testbook.XLS").Activate
Range("D2:D7").Select
Selection.Copy
Windows("TempData.XLS").Activate
Range("D2").Select
ActiveSheet.Paste

End Sub

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
vlookup failure & ctrl-f failure?	joemeshuggah	Excel Discussion (Misc queries)	4	December 22nd 08 07:22 PM
VB's Command Button vs Form's Command Button	Ronald Dodge	Excel Programming	3	May 24th 06 02:23 PM
Command Button Macro Execution Failure	Dick Scheibe[_2_]	Excel Programming	0	August 22nd 05 10:40 PM
OnAction command failure	[email protected]	Excel Programming	4	November 18th 03 07:50 PM
Command Button vs Control Button	RGibson	Excel Programming	1	October 14th 03 02:24 AM

All times are GMT +1. The time now is 08:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us