Insert "-" In Other Cells On The Same Row If Cell Value Is "SPARE"

[Storm08]

Hi All,

I have the code below, but it takes a long time to complete because of the repetitive actions.
Is there a way to make it more efficient?

Please Login or Register  to view this content.

Any help would be greatly appreciated!

Thanks,
Storm08

[TMS]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Showing extracts of codes isn't as helpful as you might think. Problems raises more questions than answers.

[Storm08]

Thanks for the response.

Sheet has been added to the original post.

[TMS]

This seems to work quicker:

Please Login or Register  to view this content.

[Storm08]

Hi TMS,

Thanks for the solution.

That definitely works a lot quicker than previously! However, is there a way to exclude some of the columns from the For loop?
The original code doesn't apply it to each cell in the row, it skips some.

[TMS]

Difficult to assess. You have all those merged cells, always a (very, very) bad thing.

The choices are:
1. Loop through all the individual cells (original and slow)
2. Fill all the cells in one go (as suggested and quicker)
3. Combine the options. Group the cells by adjusting the offset and resize values.

To be honest, when you refer to C4.Offset(,1) in relation to a merged cell, I’m not entirely sure which cell it means.

[Storm08]

Hi TMS,

Apologies for the severe delay!

I know merged cells are generally bad news, but I can't do much to get away from them on this occasion.
When you mention adjusting the offset/resize values, how would I go about trying this?

+Rep!

Cheers,
Storm