Hi all,
So i am working on a Excel Final project and i have inputed VBA code into a macro, which i intend to have a button when pressed reruns the macro and imports the live data.
Sub Live_Data()
Dim lr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
Range("A121:A" & lr).EntireRow.Delete
Range("A1:D46").EntireRow.Delete
End Sub
- This is the code i have so far. However, when i run this more then once it starts to delete more information then i need.
- So i guess what i am trying to ask is how would make it so it reloops this process so it only deletes the desired data in the worksheet?
Bookmarks