Hi all!: I taught myself how to write macros in Lotus a long time ago and now I need to learn it in Excel, but I'm an old dog trying deperately to learn new tricks (and this VBA stuff is waaay beyond the little bit of BASIC I learned a million years ago!). I've searched for this stuff, but I guess it's too basic. Please help!
I have a fairly simple schedule laid out and want to automate it as follows:
1. Move the cursor to a cell named SET (that is the first cell of a row numbered 1-6)
2. Pause, prompt the user to move the cursor to their choice of cell #1-6 (denoting the first day of a new schedule), and then resume the macro (I would guess after pressing ENTER).
3. Check that the cursor is in a cell numbered 1-6; if not, go back to Step 1.
4. Move the cursor down 1 row, anchor the cursor and select (for copying) everything below that point (end down) and to the right the number of columns specified in a cell named MDAYS (the number of days in a month)(copy a schedule block).
5. Copy that block and paste it beginning at a cell named CAL (on another worksheet page).
6. Release all selected blocks and return the cursor to the upper left cell on each page (named CALENDAR and WORKSHEET).
Fudging around, I have figured out a couple of these things, but I don't really know how to put it all together. I realize this is kindergarten stuff, but I am grateful for any help and hopeful that seeing how it's done will guide me down the line. Thanks!
I have a fairly simple schedule laid out and want to automate it as follows:
1. Move the cursor to a cell named SET (that is the first cell of a row numbered 1-6)
2. Pause, prompt the user to move the cursor to their choice of cell #1-6 (denoting the first day of a new schedule), and then resume the macro (I would guess after pressing ENTER).
3. Check that the cursor is in a cell numbered 1-6; if not, go back to Step 1.
4. Move the cursor down 1 row, anchor the cursor and select (for copying) everything below that point (end down) and to the right the number of columns specified in a cell named MDAYS (the number of days in a month)(copy a schedule block).
5. Copy that block and paste it beginning at a cell named CAL (on another worksheet page).
6. Release all selected blocks and return the cursor to the upper left cell on each page (named CALENDAR and WORKSHEET).
Fudging around, I have figured out a couple of these things, but I don't really know how to put it all together. I realize this is kindergarten stuff, but I am grateful for any help and hopeful that seeing how it's done will guide me down the line. Thanks!