Hi,
I have been using this macro for years but it is not working, I am trying to combine two sheets based on Text Field A in both sheets.
Sub CopyRange()
Application.ScreenUpdating = False
Dim LastRow As Long
LastRow = Sheets("Sheet2").Cells.Find("*", SearchOrder:=xlByRows...