personally i'll stick with my class...
further:
I'd always use Long and never Integer when working with rows.
In fact I almost never use integers. It may save 2 bytes, but slows
down the code (fractionally;) and you always have to think about it's
32k limit... In your worksheet stack it doesnt really matter if you
bounce at 32k or 65k...
I'd stay away from "personal.xls" as I think it should be reserved for
exclusive use of the user.
--
keepITcool
|
www.XLsupport.com | keepITcool chello nl | amsterdam
Antonio Elinon wrote in
kIC,
Thanks. I did notice your code can handle multiple types. My point
was to suggest that personal.xls can implement the stack and thus it
is limited to strings only, therefore the need to use Range(label)
after popping. On exit from Excel, personal.xls can be saved and the
stack will still be operational with other macros in personal.xls