Hi there,
I have a small program here that makes quite a nice simple calendar for just the one month. I have already modified it so that it automatically makes a new sheet for it in the event that someone clicks the button and over writes some valuable work, but I now want to add to it so that I can have two months on there.
The easy way would be to put in an if statement and just copy the whole code again inside the if statement with updated cell references, but it is clumsy. Is there a way to offset every cell reference in the macro by say 8 columns? The referencing of cells is "A1" type of referencing.
What would be the best way to go about this without completely rewriting the code?
Kind regards
Rob
Bookmarks