Hi,
Not sure exactly what you are trying to do but I'm assuming that you want to copy down a formula until you find the word "Powered by GL Compliance Manager" in another column assuming its column L.
Try this if you want the formula to be next to column K.
Thanks,![]()
Sub test() Dim row As Long row = 2 Do Cells(row, 12).value = "=+RC[-11]" row = row + 1 Loop Until Cells(row, 11).value = "Powered by GL Compliance Manager" End Sub
Fonzie![]()
Bookmarks