Hi,
Below is my script and its not stopping once the data is over.....Please help me on this and correct me where I am going wrong
![]()
Sub test() Dim row As Long row = 2 Range("K2").Select Do ActiveCell.Offset(0, 1).Select ActiveCell.FormulaR1C1 = "=+RC[-11]" ActiveCell.Offset(0, -1).Select Selection.End(xlDown).Select Loop Until Cells(row, 3) = "Powered by GL Compliance Manager" End Sub
Bookmarks