assign value to cell on different sheet

  • Thread starter Thread starter ranswert
  • Start date Start date
R

ranswert

How do I write a code to assign a value to a cell on a different sheet?
Thanks
 
worksheets("someothersheetnamehere").range("a1").value = 1234

or

worksheets("someothersheetnamehere").range("a1").value _
= activesheet.range("b99").value
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

execute assigned data validation in vba? 11
passing a non numeric cell for numeric comparison 2
Excel, assign cells in multiple worksheets from one sheet 1
Sheet name=Cell value 2
lastrow function help 6
Combobox list validation 1
sheet event wait for another event? 6
Copy adjacent Sheet and name from a list 42

Back
Top