How can I copy the values of all selected cells to the same cells inanother Sheet
 

Hi all,

how can I copy the values of all selected cells to the same cells in
another Sheet ?

Thanks for any help !

Hans

How can I copy the values of all selected cells to the same cells in another Sheet
 

Dim myCell as Range

For Each myCell In Selection
Worksheets("Other Sheet").Range(myCell.Address).Value = myCell.Value
Next myCell


HTH,
Bernie
MS Excel MVP


wrote in message ...

Hi all,

how can I copy the values of all selected cells to the same cells in another Sheet ?

Thanks for any help !

Hans

How can I copy the values of all selected cells to the same cells inanother Sheet
 

Thank you, Bernie,

it works fine !

Hans