Can't change the range in VBA code

[Brandt]

Hi

Sorry for the earlier post, but hope this is following the roules!

Where do I change the range in this VBA code? The range hase to be E14:G214 as below but it's not working.

Please Login or Register  to view this content.

[VBA Noob]

That range is looking at Col 5,6 & 7 so change you're select case from 1,2 & 3 to Col 5,6 & 7

VBA Noob