Changing Cell value in a sheet according to the cell value in another sheet using vba

[Arpit Modi]

I have a excel workbook.
There are two sheets 'Sheet1' and 'Sheet2'. I want to create a vba code that change the value of cell 'A1' in Sheet1 directly to value of Cell 'A1' in Sheet2 with some extra string. I used the fromula in cell A1 of Sheet 1-- ="Hello " & Sheet2!$A1. I want to do the same with VBA. Please help.

 

[NARAYANK991]

Hi Arpit ,

If you use the bracket convention , it is :

Sheet1.[A1] = "Hello " & Sheet2.[A1]

Narayan

 

[Arpit Modi]

Thanks but it is not helping me either.

 

[NARAYANK991]

Hi Arpit ,

What did you do with the statement that I posted ?

Can you post the code which you have used ?

Narayan