ExcelBanter - read from 1 cell read to and other using vba

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - read from 1 cell read to and other using vba (https://www.excelbanter.com/excel-programming/286225-read-1-cell-read-other-using-vba.html)

Henrik[_4_]

read from 1 cell read to and other using vba

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

best regards
Henrik

J.E. McGimpsey

read from 1 cell read to and other using vba

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.

In article ,
"Henrik" wrote:

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

best regards
Henrik

All times are GMT +1. The time now is 08:22 PM.