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	Peter[_8_]	Excel Discussion (Misc queries)	3	December 11th 07 02:37 AM
Range Question	N.F[_2_]	Excel Discussion (Misc queries)	5	July 28th 07 01:05 AM
range question	Simon Sunke	Excel Programming	0	February 23rd 04 02:41 PM
Range Question	Ray Batig	Excel Programming	4	January 31st 04 05:01 AM
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:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us