Wednesday, February 27, 2019

Excel popup window after using macro

This is the excel sheet i am using


enter image description here


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
enter image description here


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

hard drive - Leaving bad sectors in unformatted partition?

Laptop was acting really weird, and copy and seek times were really slow, so I decided to scan the hard drive surface. I have a couple hundr...