Add Columns to Code

Hello,

I would like to add columns 8 and 9 to the below code so that column 7 is not included. The line is ' For ApptCol = 4 To 6'

Can this be done?

The reason I want to do this is so the duration on the Schedule sheet is calculated from the start time to end time.

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

I don't love the low elegance of this solution but it will work.

Please Login or Register  to view this content.

@6SJ: hahhh, you copy my code, colour it in, and then call it inelegant!

You could have two loops: 4 to 6 and 8 to 9. Not elegant at all. But it would work.

You're welcome. Thanks for the rep.

Originally Posted by TMS

@6SJ: hahhh, you copy my code, colour it in, and then call it inelegant!

Let's just say great minds think alike! I was just slow on the draw.

I just don't like having a loop with exceptions. Some languages would allow this

Formula:

Please Login or Register  to view this content.

but not VBA.

I guess you could do this. But I can't think of a good way to express "4-9 except 7" without writing the numbers individually.

Please Login or Register  to view this content.

I quite like the array approach and, at first glance, it looks scalable. Until the OP say, "I’ve got 100 columns and I need to ignore 7 of them … 7, 23, 31, 40, 52, 67 and 82" or whatever .