Hi
I have several macros associated with a worksheet, these macro's perform various simple functions, eg. insert rows, move rows up/down etc.
What I would like is to know how to word error checking so that
Rows cannot be moved above Row 7. (Rows 1-6 contain headings so I do not want a row 7 and Row 6 switched by running this macro.
Rows 1-6 cannot deleted.
Something along the lines of "If Activecell < A7 Then ErrorMessage" etc.
Any ideas?
Apologies if not clear.
Regards
Andy
Bookmarks