I want to divide the range B116 to L130 by 1M. Some cells in this range are blank. Using the following code results in zeros for the cells with blanks. Is there a way to do this without selecting each cell to determine if its blank and if not then use the paste special code?
Range("B3").FormulaR1C1 = "1000000"
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlDivide, _