Select Case c.Address

[T De Villiers]

Hi,I am trying the following code, which emboldens A1,C1 but doesnt quite work..
Thank you in advance for any assistance

Please Login or Register  to view this content.

[Thalassa]

Try

Please Login or Register  to view this content.

[T De Villiers]

Sorry Thalassa, thank you for your prompt response.

The amendment 'Next c' does not make a difference

[Thalassa]

This was the main amendment

Please Login or Register  to view this content.

Tested and working.

[T De Villiers]

Many Thanks! Tested and confirmed