Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign Color to a Cell based on another Cell on a diff Sheet | Excel Worksheet Functions | |||
Generate sheet names from list, assign data to summary sheet. | Excel Programming | |||
Lookup numbers in sheet and assign it's cell reference | Excel Discussion (Misc queries) | |||
Variable VB to assign new sheet name | Excel Worksheet Functions | |||
Assign values to a cell in sheet A, from worksheet_change event of sheet B | Excel Programming |