assign value to cell on different sheet

's Computer Specifications

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

's Computer Specifications

worksheets("someothersheetnamehere").range("a1").value = 1234

or

worksheets("someothersheetnamehere").range("a1").value _
= 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assign Color to a Cell based on another Cell on a diff Sheet	VROSARIO7	Microsoft Excel Worksheet Functions	1	6th Jul 2009 08:48 PM
Generate sheet names from list, assign data to summary sheet.	Jason.Alden.Benoit@gmail.com	Microsoft Excel Programming	4	20th Jun 2007 09:17 PM
How do i assign cell A1 to show the current cursor cell in Excel?	=?Utf-8?B?T0I=?=	Microsoft Excel Misc	2	11th Oct 2006 04:02 PM
Lookup numbers in sheet and assign it's cell reference	dgraham	Microsoft Excel Misc	10	7th Apr 2006 02:16 AM
Assign values to a cell in sheet A, from worksheet_change event of sheet B	Arif Khan	Microsoft Excel Programming	1	4th May 2004 04:51 AM