Avoid each third cell while copying or pasting a range.

[shaju]

I have a range to copy and paste.
The range is Sheet2.Range("BA3:EF3"), but the catch is that each third cell should be avoided....either while copying OR when it is pasted to another location.
First part is like:

Sheet2.Range("BA3:BB3,BD3:BE3,BG3:BH3,BJ3:BK3,BM3:BN3,BP3:BQ3,BS3:BT3,BV3:BW3,BY3:BZ3,CB3:CC3,CE3:CF3,CH3:CI3,CK3:CL3,CN3:CO3,CQ3:CR3,CT3:CU3,CW3:CX3,CZ3:DA3,DC3:DD3,DF3:DG3,DI3:DJ3,DL3:DM3,DO3:DP3,DR3:DS3,DU3:DV3,DX3:DY3,EA3:EB3,ED3:EE3").Select

Because the second location where it is to be pasted has formulae in all third cells.
Second location is Sheet6.Range("B" & i ":CJ" & i) where i is a variable


I am confused mainly with second part ie, pasting it. But, any help with the first part also welcome.

Any ideas, insights...etc most welcome

 

[shaju]

The marked solution has been changed accordingly.
In your future questions, please mark the post as the solution that answered your question instead of your feedback message as it will help future readers. No further action is required for this thread.

Sorry. Kindly excuse.
Shall be more alert in future.

 

[Peter_SSs]