read from 1 cell read to and other using vba

  • Thread starter Thread starter Henrik
  • Start date Start date
H

Henrik

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

best regards
Henrik
 
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.
 
Back
Top