Hello,
I have a very large list of emails around 200,000 and I need to split them into several sheets of 40,000 on each. I have been able to accomplish this with the following but how do I copy the headers over to each sheet?
Sub SplitWorksheet()Dim lngLastRow As Long
Dim lngNumberOfRows As...