ttbengineer
asked on
Excel paste special to range but skip blanks
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"
Range("B3").Select
Selection.Copy
Range("B116:L130").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlDivide, _
SkipBlanks:=True, Transpose:=False
Range("B3").FormulaR1C1 = "1000000"
Range("B3").Select
Selection.Copy
Range("B116:L130").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlDivide, _
SkipBlanks:=True, Transpose:=False
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER