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

[[email protected]]

Hi all,

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

Thanks for any help !

Hans

[Bernie Deitrick]

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


<[email protected]> wrote in message news:[email protected]...

Hi all,

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

Thanks for any help !

Hans

[[email protected]]

Thank you, Bernie,

it works fine !

Hans