If selected range is not in desired range

[jomili]

I have a tool for my users to create a folder structure for them using a workbook. My macro begins with:

Please Login or Register  to view this content.

There are various formulas to help them construct the basic structure they want, then they need to Select the rows describing the desired structure, then press the "Go" button.

I'm trying to make this as idiot-proof as I can. The desired rows should be in column B, starting at B10 and continuing down a number of rows (variable). How do I flash a warning if they've accidentally selected say, D5:E17, IE they selected something OTHER than their desired folder structure?

[TMS]

I'm trying to make this as idiot-proof as I can.

Good luck with that

You can use the Selection Change event handler to monitor what cells are selected and the Change event handler to monitor changes to values (not formulas).


Regards, TMS

[Richard Buttrey]

Hi,

One way as the first bit of code in your 'Go' macro

Please Login or Register  to view this content.

[jomili]

Sorry it's taken me so long to get back to this thread. I used Richard's method as shown below. And thanks Richard; I learned something new. Usually when I have a check in a macro, if the check requires restarting I put "Exit Sub"; I never saw "End" used to exit a macro (shows how educated I am) so I was glad to learn that. Thanks to both of your for your help.

Please Login or Register  to view this content.