Get the content from the fixed cell & variable cell and combine it

[Ann_BBO]

Hi all

I have the one minor VBA marco question which is how to get the content from the 1 fixed cell to combine with the variable content from other cell.

For Example,in B2=115V which is the Fixed cell. B3=400mA, B4=300mA, B5=200mA, B6=100mA which are the variable cell(Contents is variable).

Therefore, i want to write the marco which can change the B3="115V/400mA", B4="115V/300mA", B5="115V/200mA".....base on the B2(Fixed cell)

Thanks
Ann

[rory]

Something like:
[VBA]Range("B3").Value = Range("B2").Value & "/" & Range("B3").Value[/VBA]