Hello,
I created a macro and it work great on the file that I created it with. I need to be able to run this same macro on new spreadsheets that I download where the number of rows varies as well as the file name/tab name.
I am getting this error, but I suspect I will have more errors because of my lack of understanding the correct coding. The error occurs at the highlighted line.
I am basically trying to get it to sort by selecting Row 2 to all rows with data and then the items following I was sorting by Column C, B & E to which I also need it to know that the number of rows will vary.
I appreciate any help anyone can offer. Please forgive me as I am learning and am a novice user of VBA.
I created a macro and it work great on the file that I created it with. I need to be able to run this same macro on new spreadsheets that I download where the number of rows varies as well as the file name/tab name.
I am getting this error, but I suspect I will have more errors because of my lack of understanding the correct coding. The error occurs at the highlighted line.
I am basically trying to get it to sort by selecting Row 2 to all rows with data and then the items following I was sorting by Column C, B & E to which I also need it to know that the number of rows will vary.
I appreciate any help anyone can offer. Please forgive me as I am learning and am a novice user of VBA.