|Ok, lots to deal with here, and not necessarily in order. Keep in mind that I can only run the code against a test workbook that I set up, not your actual workbook, unless you send it to me. That said:|
re: "I have a filtered view of, say, 500 rows, and most often EXCLUDING worksheet rows 1 or 2, and even so, the code DOES work to select every nth row"
When I run the code against an unfiltered workbook, it only Selects every nth row if Row 1 or 2 is included in the selection. Otherwise it only selects the first row of the original selection. At least that is what my limited testing has shown. Perhaps the filtering has something to do with that, but as I said earlier, I can't replicate your exact environment without the workbook.
re: "the COM add in called "Kutools" also enables the selection of every nth row, and in addition, DOES allow up to 18 copy and pastes of non-contiguous rows as long as one selects the 18 paste-to locations individually, so this leads me to believe there is some capability for excel to at least copy and paste a range of non-contiguous cells "
Keep in mind what an add-in actual is.
Stolen without permission from: http://fontstuff.com/vba/vbatut03.htm
"An Excel Add-In is a file (usually with an .xla or .xll extension) that Excel can load when it starts up. The file contains code (VBA in the case of an .xla Add-In) that adds additional functionality to Excel, usually in the form of new functions."
While it may appear that Excel is performing a Copy/Paste of non-contiguous cells, I'll wager that what is really happening is that the VBA code inside the Add-in is looping through the selected cells and doing the Copy/Paste one at a time. That is what I meant when I mentioned this in my previous post. The code could still select every nth row all at once as it does, but the address of newly selected range would be used to allow VBA to loop through it and do a Copy/Insert-Paste one row at a time. I'm not suggesting that the user needs to be involved any more than to select the original range to work on. VBA will be doing the looping.
re: "Well, the extraneous data would be located on columns AB-AV on every 3rd row in the midst of 500 other rows how would I isolated that data before I delete it, as it is a copy the data from the row below it... unless I loop through each 3rd row individually"
I don't think you can avoid looping through each row in the new selection (e.g. every 3rd row) for the reasons I've stated above. I could be wrong, but I do not believe that it is possible to do a mass Copy/Paste (Insert or not) of non-contiguous cells with Excel. Try this:
Select A1, A3 and A5, Ctrl-c to Copy
Select A2, A4 and A6, Ctrl-v to Paste
Read the error message that appears. If you can't do it in Excel, you aren't going to force VBA to to do it.
Therefore, in the same loop that does the Copy/Insert-Paste of the entire row, we would simply add another instruction to delete all data beyond the last column that we want. This would be done right after the Insert/Paste operation.
Since I don't have a copy of your workbook, and don't have a clear understanding of how you select the filtered range to "Insert/Copy" it's kind of hard for me to create a macro that will do exactly what you want.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.