VBA that Recognises Numbers only Once

[Floydlevedale]

Hi All

In column A I have a list of numbers values [ 1 → 200 ] , in this list the numbers are repeated randomly, so there may be [ 10 x 105's , 1 x 199 , 52 x 5 etc...... ] sometimes the values in colum A only go up to 100 or 50 or 200. So I need a macro that will determine if on this sheet the max value is say 112 and then list these values in a range B1:B112 , with the numbers 1→112 [ so the numbers are always sequential. It sould do this for all the sheets in the workbook

Thanks in advance

[Bernie Deitrick]

Try this:

Please Login or Register  to view this content.