alvshill Posted March 20, 2007 Report Share Posted March 20, 2007 For some strange reason my prefix keys, which are "--" are not consistently removed in Excel when I try to trigger a macro from a cell. Sometimes the prefix completely removes itself, other times it removes a single "-", and at other time it doesnt removed the prefix at all. Does anyway know why this happens and/or how I can fix it? I'm using version 3.5.5.1 (3.5e build 1). While here I must say, so that that the world can see, Macro Express is the best thing since bread slicing machines were invented! I am called Macro-man at my place of work. Quote Link to comment Share on other sites More sharing options...
alvshill Posted March 20, 2007 Author Report Share Posted March 20, 2007 You wouldn't believe it but after at least a few years of suffering this issue and within a couple of minutes of posting the issue, I've just thought of and tried a workaround. It is to introduce a short delay, 0.4 seconds in this instance, and the shortkey prefix completely removes itself every time. I guess MacExp is just too quick for Excel. Quote Link to comment Share on other sites More sharing options...
Cory Posted March 20, 2007 Report Share Posted March 20, 2007 If you deal much with Excel I can tell you another trick… Don’t type, paste. Check this out… When you copy to the clipboard from Access, Excel, Outlook and dozens of other programs and read it into a text variable or paste it into a text file it’s a tab separated values file! And in Access and Outlook it even grabs the header for you if you have a single record selected. I use this all the time and simply chew thru the text var to get what I need and it works great. On the output side you can paste into cells as well. For instance you can assemble a row or rows of cells in a text variable using the TAB and CRLF and when you paste them in they’re all in order. Saves tons on timing issues. That combined with F5 makes working with Excel a breeze. Quote Link to comment Share on other sites More sharing options...
blopib Posted March 21, 2007 Report Share Posted March 21, 2007 Nice Excel tip Cory! Quote Link to comment Share on other sites More sharing options...
Cory Posted March 21, 2007 Report Share Posted March 21, 2007 Thanks. Let me tell you I was a very happy camper the day I discovered that one. It's nice when working in Excel to be able to massage a bunch of cells in place for the user without haivng to go cell by cell. I have one that reformats social security numbers and one can have hundreds highlighted and it's done in a blink. In fact the users often don't even realize it's done anything! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.