read from 1 cell read to and other using vba

H

Henrik

hi
how can i read from one cell and the write the result to another cell using
vba

best regards
Henrik
 
J

J.E. McGimpsey

one way:

Range("A1").Copy Destination:=Range("B1")

If you only want to write the value:

Range("B1").Value = Range("A1").Value

avoids the clipboard.
 
Top