Posted to microsoft.public.excel.programming

Oldjay

external usenet poster

Posts: 337

Command button failure

What row did you replaced??

"Kari J Keinonen" wrote:

Hy!

I don't replace that row.

Regards Kari J Keinonen

"Oldjay" wrote:

When I replace "Windows("TempData.XLS").Activate" with

Workbooks("TempData.XLS").Sheets(1).Range("D2").Se lect

I get a 1004 "Select method of Range class failed" at this new line

oldjay

"Kari J Keinonen" wrote:

Hello!

I change one row, and it works me!

Workbooks("TempData.XLS").Sheets(1).Range("D2").Se lect

Regards Kari J Keinonen

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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 02:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us