Thread: assign value to cell on different sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default assign value to cell on different sheet
worksheets("someothersheetnamehere").range("a1").v alue = 1234

or

worksheets("someothersheetnamehere").range("a1").v alue _
= activesheet.range("b99").value

ranswert wrote:

How do I write a code to assign a value to a cell on a different sheet?
Thanks

--

Dave Peterson
Reply With QuoteReply With Quote