Posted to microsoft.public.excel.programming

Luc[_3_]

external usenet poster

Posts: 24

Sheets("sheet1").Range command between workbooks

I would like to use the e.g.
Sheets("sheet1").Range("ac2") = Sheets("sheet2").Range("b2")
command (which works within a wookbook) but between 2 workbooks. How can I
impose a value of workbook1 to workbook2 in the assumption that wookbook2 is
open?

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
Sheets("Sheet1").Cells.ClearContents	Seeker	Excel Discussion (Misc queries)	2	October 1st 09 12:00 PM
How to TURN OFF "wrap text" for all new workbooks/sheets	MK	Excel Discussion (Misc queries)	3	March 16th 07 01:03 PM
"Subscript out of range" error for: Workbooks("Test1.xls").Save	Just12341234	Excel Programming	2	June 17th 05 03:16 PM
FileCopy Command Giving "Subscript Out of Range" Error Message	Jim Hagan	Excel Programming	2	June 15th 05 06:07 PM
Range only works when Sheet Name is "Sheet1"	paul reed	Excel Programming	4	September 14th 03 08:37 PM

All times are GMT +1. The time now is 12:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us