I have some rather large spreadsheets that began life as MS Excel books. And i’m slowly converting the underlying macro from VB (written by me) to Libre. Needless to say, the learning curve is steep and requires a lot of google’ing. The upshot of the question relates ‘CreateCursor’ method on sheet objects. I see many code snippets from responders referring to it, but i cannot find any info on what it actually is or what it does or how to use it. I’m guessing that it moves the range structure access from i/o to RAM, effectively treating the sheet as an in in-memory array. Grateful for any help, pros/cons.
thx