Auto-highlighting

[hopp]

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.

 

[xlbo]

yes - have a look ath the OFFSET function

how would you like to specify how many rows / columns etc ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[hopp]

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.

 

[xlbo]

yes - I get that - my question was how you intend to know how many rows & columns are needed ??? user input ?? always the same ?? from the spreadsheet ???

If it is always 50 rows & 5 columns then you can simply use the OFFSET function

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[hopp]

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.

 

[hopp]

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