VBA code to loop through a range of selected cells, to add to my macro

Hi, I am new to VBA and have been struggling with this problem.

In the attached excel document worksheet 1 is called 'manufacturing bom'

I have a button called create revision, which is driven by a macro called 'Rev B'

This macro creates a copy of a new work sheet & names it whatever is in cell 'D5' eg Rev A,

I would like the value in cell D5 to change every time I press the create revision button, eg Rev A, Rev B, Rev C etc so it automatically creates a new sheet with the next name in the loop, to save me manually changing it each time.

I cant work out the code for this?

Hopefully someone can help me with this?

Thanks

Craig

Here is Function that might help you. Just add a line a code to call it form your Create Revision macro.

What it does it converts the revision letter into ASCII code and increments it by 1 to get to the next letter.

Please Login or Register  to view this content.