Recursion in VBA macros?
I'm writing macros under Excel 2003/XP on a fairly powerful PC to process
financial data.
When I'm searching an almost full column for the next non-blank entry I
don't have any problem using recursion, but when the column is mostly blank
I wonder whether I'm doing the right thing.
Are there any guidelines for using recursion under VBA? I use instance
variables instead of locals, but that's about all I know.
Thanks for your help,
Peter
|