Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying cells
Hi Erik,
See reponses i n your other thread. --- Regards, Norman "Erik" wrote in message ... I am currently using the following code: Private Sub Worksheet_Change(ByVal Target As Range) 'Copy the cells With Worksheets("Sheet2").Range(Target.Address) .Value = Target.Value End With End Sub This copies all cells from sheet1 to sheet2. How can I modify this to copy just a specified range of cells? Erk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cells | Excel Worksheet Functions | |||
Copying Cells | Excel Discussion (Misc queries) | |||
How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
Excel should allow cloaking of certain cells when copying cells b. | Excel Worksheet Functions | |||
Copying cells | Excel Programming |