View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gustaf Gustaf is offline
external usenet poster
 
Posts: 69
Default Set range to value from another sheet

What's wrong with this code?

Range("Sheet1!B4:AE4") = Cells(2, 1)

This is written in the Sheet2 code, and it's supposed to change a range
of cells on Sheet1 to a single value set on Sheet2. I get the 1004 error
(i.e. undefined error).

Gustaf