Loop Within an Excel Macro

S

steve

Dear All,

i have a small problem i hope somebody can sort out please


I have a value in a cell E2 on a tab
This value is obtained from a drop down list somewhere else on the same
tab and the value is copied to cell E2 This number ranges from 1 to 256
but this number could get bigger in the future

what i need to know is how i can start this number at 1 the run variuos
macros and then let Cell E2 value= E2+1 and then run the macros again

When the value of E2 =256 the run the macro for a final time and then stop



Can anybody help me on this one please

Many Thanks in advance


Steve

PS

Further info

the value in E2 is used to Autofilter and copy data to other tabs in my
spreadsheet

Cheers


Steve
 
Top