Solution to change cell range to array
In the below solution, I have made a Sub to define array (defineArray), a Sub to delete worksheet(delWS), a Sub to move worksheet(moveWS)
First, I define an array at Module level, so that all Sub within the Module can access the array.
In Sub defineArray(), I put all the items from Range A4 to the last row of column A into wsArray()
In Sub delWS(), I put "On Error Resume Next" to prevent error message when Macro tries to delete a wor...
Read More