J
jesmin
Hi Anyone:
I have 2 worksheets.
Sheet1:
-----Col:
RN:-A--B--C---D
1----2--4--""---8
Cell C1 has a blank data. I want to copy this data into sheet2 startin
from colB to colE at row num 5 as follows. The blank data to be replace
by 0.
Sheet2:
-----Col:
RN:-A--B--C--D--E
5-------2---4--0--8
I wrote down in VB:
Sheets("Sheet2).Range("B5:E5).Valu
="=If('Sheet1'!A11="""",0,'Sheet1'!A11)"
--Why the code is giving wrong results.
Thanks a lot for any help
I have 2 worksheets.
Sheet1:
-----Col:
RN:-A--B--C---D
1----2--4--""---8
Cell C1 has a blank data. I want to copy this data into sheet2 startin
from colB to colE at row num 5 as follows. The blank data to be replace
by 0.
Sheet2:
-----Col:
RN:-A--B--C--D--E
5-------2---4--0--8
I wrote down in VB:
Sheets("Sheet2).Range("B5:E5).Valu
="=If('Sheet1'!A11="""",0,'Sheet1'!A11)"
--Why the code is giving wrong results.
Thanks a lot for any help