Apply VBA Code to 2 Columns, then skip one and repeat.

[Ernestas98]

Hi All,

I have a piece of code here and I need to adjust the range to take into account new amendments made to the spreadsheet.

I am adding a new column before the code range and a column after every 2 columns in the code range. I will add a screenshot of the spreadsheet and where the new columns will be.

What I need the code to do is to work in the same columns it does now as otherwise it shifts by one and disrupts the whole spreadsheet.

Here's the code:

Please Login or Register  to view this content.

Columns will be added here (in red) added columns in red.PNG

[Norie]

It's not clear from the image exactly what the new set up is, can you upload a sample workbook?

[sintek]

Welcome to our Forum...

Please take a moment to read our forum rules...here
Your post does not comply with Rule # 2
2. Programming code must be enclosed in code tags to improve readability.

Please Login or Register  to view this content.

So...Edit your post...Highlight the code and press the # button

[Ernestas98]

It's not clear from the image exactly what the new set up is, can you upload a sample workbook?

Attached here

[Ernestas98]

Welcome to our Forum...

Please take a moment to read our forum rules...
Your post does not comply with Rule # 2
2. Programming code must be enclosed in code tags to improve readability.

Please Login or Register  to view this content.

So...Edit your post...Highlight the code and press the # button

Updated, thank you

[Norie]

So starting in column G for every 3 columns you want the first 2 columns to trigger the code but not the 3rd column?

[Ernestas98]

So starting in column G for every 3 columns you want the first 2 columns to trigger the code but not the 3rd column?

Yes

So that the tick is in the "Shared?" column, the date in the "Date" and "likes" column is left for manual input

Thank you

[Norie]

Try this.

Please Login or Register  to view this content.

[Ernestas98]

Try this.

Please Login or Register  to view this content.

That worked perfectly! Thank you for saving the day again )