Simon,

Try this

Range("B19:C19").Value = Range("A2:B2").Value

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Simon Sunke" wrote in message
...
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