complady22
03-09-2022, 07:30 PM
I am VERY new to VBA and using a macro code that I found on YouTube. The code splits a sheet into multiple sheets by a filter that you identify as the "splitcode". This has worked for me many times but for some reason will not work with this sheet. I keep getting the run-time error '1004' that it cannot use that command on overlapping selections. This workbook has a lot of formulas built into it but I don't think that is what's causing the error. The debug says it's erroring out on this line:
".0ffset(1,0).Specialcells(xlcelltypeVisible).EntireRow.Delete"
It will copy the sheet, filter by the header of the column I pick but then when it goes to delete everything that doesn't match the filter, it says it cannot. I do have some blank cells in here but not entire rows or columns.
PLEASE HELP, need this for work in TONIGHT!
".0ffset(1,0).Specialcells(xlcelltypeVisible).EntireRow.Delete"
It will copy the sheet, filter by the header of the column I pick but then when it goes to delete everything that doesn't match the filter, it says it cannot. I do have some blank cells in here but not entire rows or columns.
PLEASE HELP, need this for work in TONIGHT!