Thread: range question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon Sunke Simon Sunke is offline
external usenet poster
 
Posts: 10
Default 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