C
Corey
I want to have in the = Sub Worksheet_SelectionChange(ByVal Target As
Range):
*********************************
H9=IF(D9*F9>0,(D9*F9),"")
H10=IF(D10*F10>0,(D10*F10),"")
.....
.....
.....
.....
same down rows till row 48
.....
.....
H48= =IF(D48*F48>0,(D48*F48),"")
*********************************
Is there a way i can condense this to not have a mass of code for each
separate reference to each cell from row 9 to row 48?
Corey....
Range):
*********************************
H9=IF(D9*F9>0,(D9*F9),"")
H10=IF(D10*F10>0,(D10*F10),"")
.....
.....
.....
.....
same down rows till row 48
.....
.....
H48= =IF(D48*F48>0,(D48*F48),"")
*********************************
Is there a way i can condense this to not have a mass of code for each
separate reference to each cell from row 9 to row 48?
Corey....