Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning values from source cells
I'm trying to assign value from Source cells into the destionation cell using
following statements. dCell.Value = sCell.Value Is it possible to assign value in destination cells without using multiple copy-paste? -- Thanx & regards, Asif |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning values from source cells
If you create a Range object you can assign a string value to it
directly, and all the cells in the range will take on that value. Dim rng as Excel.Range Dim myval As String Set rng = Range("A1:A10") myval = "Do it!" rng.Value = myval HTH, JP On Aug 12, 3:16*pm, Asif wrote: I'm trying to assign value from Source cells into the destionation cell using following statements. dCell.Value = sCell.Value Is it possible to assign value in destination cells without using multiple copy-paste? -- Thanx & regards, Asif |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning values to adjacent cells from a function | Excel Worksheet Functions | |||
Assigning values to other cells from one cells formula | Excel Discussion (Misc queries) | |||
Linking cells: open source to update values | Excel Discussion (Misc queries) | |||
Problem assigning values to a range of cells | Excel Programming | |||
Assigning data source to chart | Excel Programming |