Hot answers tagged

5

Amazing code as always, Mathieu and Comintern; many thanks. I'm here only two add two cents: Probably you tested it in a 32 bits setup; to compile in a 64 bits you need to (only differences): #If Win64 Then Private Declare PtrSafe Sub CopyMemory Lib "kernel32.dll" Alias "RtlMoveMemory" (hpvDest As Any, hpvSource As Any, ByVal cbCopy As LongPtr) ...


5

When writing any kind of event method, I always try to minimize the code that executes because you don't want the user to be aware of processing that is happening between the keystrokes. In your case, your code is firing each time ANY cell on ANY sheet is changed. So in the spirit of keeping things streamlined, don't create, initialize, or perform any logic ...


1

Unfortunately it's difficult to provide actionable advice here, because the purpose you are trying to achieve is not explained. What would help is sample data, and a clear description of what your script does. I cannot guess what you are doing, I have no idea if all that even makes sense, surely there must be a better way but we need more insight. Besides, ...


Only top voted, non community-wiki answers of a minimum length are eligible