Greedquest

Results 49 comments of Greedquest

Yes I frequently switch to Excel to find the "find symbol" dialogue open; didn't realise this was the cause, but sounds plausible

Does the same thing happen if you change that to `msgbox` not `debug.print` . And also try adding `option explicit` below the annotation but above the sub. Or even a...

(I can repro this) Excel Windows 11 latest rd pre-release. Also another way to manage this is to remember the (configurable) shortcut ctrl+m to indent the current module only, reducing...

I added a new keyword REVIEW which is the kind of note I want to see a to-do for anyway.

Or `Application.Run` which is the same as a macro entry point but stringly typed so maybe harder to observe.

Well the principle for other projects is that it's not RD's concern e.g refactor->rename on some member of the public API will only modify call sites RD knows about, if...

Could you possibly add a concrete example of what happens to your VBA and worksheet formula before and after? I'm struggling to visualise it sorry. (Ps I'm not an RD...

@jim-oflaherty-jr-qalocate-com You can save a spreadsheet in compatibility mode to target any version of excel and flag potential formulae incompatibilities (as well as other things like Tables or formatting that...

@jim-oflaherty-jr-qalocate-com Sorry I was thinking of the [compatibility checker](https://support.microsoft.com/en-us/office/save-an-excel-workbook-for-compatibility-with-earlier-versions-of-excel-169a0336-965b-4430-8554-4e7b5db79947#:~:text=run%20the%20compatibility%20checker%20for%20excel%202007%20and%20later). As far as I know 64-bit and 32-bit _Excel/Office_ are basically the same ([here](https://docs.microsoft.com/en-us/office/client-developer/shared/compatibility-between-the-32-bit-and-64-bit-versions-of-office)'s all I could find), you might want...

@dedale OK, thanks I see - had not run install no. That seems sensible as pyenv manages (can remove) its installations so shouldn't be able to access Anaconda's. Does pyenv-win...