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

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


<hans.domian@de.man-mn.com> wrote in message news:eb9p5e$d4f$1@news2.mn.man.de...

Hi all,

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

Thanks for any help !

Hans

Thank you, Bernie,

it works fine !

Hans