This is the excel sheet i am using
When i run this macro
Sub Value_fla()
Dim k As Long
With ActiveSheet
k = .Cells(.Rows.Count, "D").End(xlUp).Row
End With
Range("D2:D" & k).Formula = Range("D2").Formula
Range("F2:F" & k).Formula = Range("F2").Formula
Range("G2:G" & k).Formula = Range("G2").Formula
Range("D3:D" & k) = Range("D3:D" & k).Value
Range("F3:F" & k) = Range("F3:F" & k).Value
Range("G3:G" & k) = Range("G3:G" & k).Value
End Sub
i got this popup window
and if i press cancel macro works fine. How can i get rid off this window??
any tips??
Excel version 2010
No comments:
Post a Comment