Hi, So I have a loop at the bottom of this code and I need it to select the cell A1 in the respective sheet at the end. This code creates a runtime error "select method of range class failed" for some reason and I dont see why.
Public Sub flattendata()
Application.ScreenUpdating = False...