assign value to cell on different sheet
 

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

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