Hi Team,
I am using below code to fill down existing formula,
its very lenghty code can we shorten below code, by using any alternate Way
Thanks
mg
I am using below code to fill down existing formula,
its very lenghty code can we shorten below code, by using any alternate Way
VBA Code:
With ws_Master
With .Range(.Cells(2, 4), .Cells(lr_new, 4))
.FillDown
End With
With .Range(.Cells(2, 5.Cells(lr_new, 5))
.FillDown
End With
With .Range(.Cells(2, 7), .Cells(lr_new, 7))
.FillDown
End With
With .Range(.Cells(2, 9), .Cells(lr_new, 9))
.FillDown
End With
With .Range(.Cells(2, 11), .Cells(lr_new, 11))
.FillDown
End With
With .Range(.Cells(2, 14), .Cells(lr_new, 14))
.FillDown
End With
With .Range(.Cells(2, 15), .Cells(lr_new, 15))
.FillDown
End With
With .Range(.Cells(2, 18), .Cells(lr_new, 18))
.FillDown
End With
With .Range(.Cells(2, 20), .Cells(lr_new, 20))
.FillDown
End With
end with
Thanks
mg