Quote Originally Posted by dimsumpanda View Post
How come the commas go inside the quotation marks? I tried to move them and I got an error. Is it because the '& 'connects the two strings together? (I'm still very new to the VBA syntax)
If you record a macro of you selecting those columns you get:
Range("A:C,E:F,L:L").Select
from which you can see where the commas go. Duplicate that.
Quote Originally Posted by dimsumpanda View Post
Hmmm... I looked up intersect and UsedRange. I understand intersect now, but what does UsedRange do here?:
Intersect(.UsedRange, .Range("A:C,E:F,L:L")).Copy SummarySheet.Cells(NRow, 1)
Add a new sheet, put something in C10 and something in F3, then in the Immediate pane (Ctrl+G if you can't see it in the VBE) type:
Activesheet.usedrange.select
then look at the sheet. This should give you a good idea of what it is.
Excel's own help says: "Returns a Range object that represents the used range on the specified worksheet."