I'm using the below code to copy/paste range into a worksheet.
I'm trying to modify the code so that it will paste the range items in Column ("A3") until ("A80") and then skips a column ("F") and continues entering the range items again in column ("G3") until ("G80"). Ditto for that column, skips column ("L") and continues entering range items in column ("M3") until ("M80")
[VBA]Select Case FListboxMover.PosList.Value
Case "TOP200"
Range("Heading1").Copy Range("A1")
Range("TOP201").Copy Range("A3")
[/VBA]
Thanks,