What do you mean by "steps of macros"? If you mean, "how many lines of
code", the answer is "thousands". However, you probably don't want to
maintain procedures with that many lines of code. You should break up the
code in to (many) separate procedures.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)



"Macros in Excel" <Macros in wrote in
message ...