Calculations in VBA
I have a Named Range called "Data_Cells"
[='Sheet1'!$F$20:$L$31,'Sheet1'!$N$20:$O$31,'Sheet1 '!$O$42:$O$44)]
Now I wish to divide each cell in "Data_Cells" with the value in "P15"
using VBA like...
For Each cell in "Data_Cells"
Data_Cells.value/P15
Exit for
Please help
|