Hi all,

I have a problem and don't know how to fix it.
I will explain what i want to do with the macro.

I have a form where users can fill in a beginweek and an endweek.
Now i want excel to place the beginweek in cell B10 and the next wee
in cell C10 and so on. After excel did that i want excel to delete al
the columns behind the endweek.

Example: beginweek is week 10 and endweek is week 21. So cell B1
should be 10, cell C10 should be 11, cell C12 should be 12 and so o
till cell M10 is 21.
Excel then should delete every column behind column M, so from colum
N.

Is this possible with a macro??

Then, is it also possible when i have a beginweek of week 48 and i
ends in week 5 of the next year...to have it automatically, after wee
52 or 53, start with week 1? I hope this is possible.

Many thanks in advance!!!

Greets Han

--
Hans
-----------------------------------------------------------------------
Hans_'s Profile: http://www.excelforum.com/member.php...fo&userid=2561
View this thread: http://www.excelforum.com/showthread.php?threadid=39031