0
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
1It seems that some data in your sheet a linked to 'Data.xls' file. Possibly, Excel can't find the file when trying to refresh data. Question, what you need to do? Is is allowed to break all links to external files?? Or maybe you could better find that missing file and set the location of it. We advise you accordingly... – Kazimierz Jawor – 2013-04-11T14:01:32.413