Ann_BBO
01-03-2008, 07:10 AM
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
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