PDA

View Full Version : Solved: Insert Value of Selected cells to another Cells



Nader
12-05-2011, 04:15 AM
I tried this way to insert the seleted cells value and offset of selected cells vlaue to another cells in another sheet, but didn't success.

Sheets(2).Cells(2,4).Value=Sheets(1).Cells.Select .Offset(3, 2).Value
Sheets(2).Cells(1,3).Value=Sheets(1).Cells.Select .Offset(2, 1).Value

Bob Phillips
12-05-2011, 05:53 AM
Maybe



With Selection

Sheets(2).Cells(2,4).Value = .Offset(3, 2).Value
Sheets(2).Cells(1,3).Value = .Offset(2, 1).Value
End With

Nader
12-05-2011, 09:24 AM
Thank you for help