PDA

View Full Version : Get the content from the fixed cell & variable cell and combine it



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

rory
01-03-2008, 07:31 AM
Something like:
Range("B3").Value = Range("B2").Value & "/" & Range("B3").Value