The code below is working for me to find and move the Order ID column. However, I'm using down to row 50,000. How do I incorporate Last Row instead of using just a generic row 50,000?
Column F will always have data all the way down.
Thanks for the help
Column F will always have data all the way down.
Thanks for the help
VBA Code:
'Find and Place "Order Id" Column
Set fnd = Range("1:1").Find("Order_Id", , , xlWhole, , , False, , False)
If Not fnd Is Nothing Then
Intersect(Range("1:50000"), fnd.EntireColumn).Copy
Range("F1").Insert Shift:=xlToRight
Intersect(Range("1:50000"), fnd.EntireColumn).ClearContents
End If