Greetings,
I am in spot of bother.I have 13000 lines in which there will be various ranges that need to be evaluated.The ranges are broken up by a blank line.The ranges are defined by duplicates in Column C.There may be no duplicates,1,2,3,4 etc.I need to establish the range and then loop through this dynamic range doing stuff through Select Case.Once I have evaluated all the cells in this range,move to the next range and evaluate it.
Thanks
Budge
I am in spot of bother.I have 13000 lines in which there will be various ranges that need to be evaluated.The ranges are broken up by a blank line.The ranges are defined by duplicates in Column C.There may be no duplicates,1,2,3,4 etc.I need to establish the range and then loop through this dynamic range doing stuff through Select Case.Once I have evaluated all the cells in this range,move to the next range and evaluate it.
Thanks
Budge