Posted to microsoft.public.excel.programming

Simon Sunke Simon Sunke is offline

external usenet poster

Posts: 10

range question

hi

why doesn't that piece of code work:
table1.range("B19","C19") = table1.range("A2","B2")
or
table1.range("B19:C19") = table1.range("A2:B2")

both do not work. I want to copy the content from table5 at A2:B2 to table1
at B19:C19

when I only select one cell, like this: range("A2"), it works great.

thanks for your help
Simon

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
Range question in '97	Adam Kroger	Excel Discussion (Misc queries)	10	December 12th 05 03:44 AM
set range question	David Goodall	Excel Programming	1	February 23rd 04 02:12 AM
Range Question	Ray Batig	Excel Programming	4	January 31st 04 05:01 AM
If Range.Name question	Otto Moehrbach[_5_]	Excel Programming	8	November 30th 03 11:05 PM
Range.Formula and Range question using Excel Automation	[email protected]	Excel Programming	0	September 19th 03 04:53 AM

All times are GMT +1. The time now is 06:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us