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
Microsoft ExcelVisual Basic Classic
Last Comment
ttbengineer
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you Wayne. That worked just like I wanted. I appreciate the help!