Search results for query: *

Woohoo, i got something to work. Thank you very much!

Oh, my bad I didn't understand what you were asking. It will always be 50 x 5. Its a spreadsheet for scheduling for the whole year. They break it up by weeks, hence the 5 for 5 days per week. I'll check out the offset function.

For example, i want them to select the cell b3. After they make this selection, i want the macro to select 50 cells down and 5 cells over. So now we have a total 250 cells selected.

Never got to say thanks yesterday. Thank you :)

Is there a way in excel that you can click a starting cell then have the macro highlight a certain number down and across? I'm trying to make this procedure idiot proof and as I have it now, you need to highlight the cells manually which could cause error. Thanks.

Was wondering whats the command that i can pause the macro in excel so the user can select another group of columns then it contineues excecuting the code. Anyone have any help?

I'm trying to write a macro in which it copy and pastes cells from 1 sheet to another. However, as i have it now, i can only select 1 column at a time because im trying to make the macro's usable for any area in the sheet. Is there any way to specify a start point then have the macro increment...