Excel 2007 Visual Basic Editor: eats spaces, throws cursor around
- by Vincent
I can't resolve this issue, I found a similar question here but:
setting the workbook to Manual calculation (alt-m-x-m or alt-t-oformulas) didn't work
Setting editor options to disable: Auto syntax check & Background compile didn't work
anybody have any idea how to fix this very annoying behaviour, I'm used to quickly pop up VBA (alt-f11), f7 to get into code and write some quick procedures there... and it's hard to get out of that habit, I don't want to write any office extension to just add a single quote to every cell in the range
For Each rg In Selection
rg = chr(39) & rg.value
Next
F5, done...