Hi All
The code below works perfectly on MS Excel 32-bit, but since upgrading to 64-bit it constantly crashes. I think this is happening at the .value = .value stage, I have tried copy/paste but no luck...
I have been researching the problem and believe it may be related to 'declarations and pointers'? I have changed Long to Longptr but that doesn't seem to have fixed the issue so any help/advice as always would be greatly appreciated
Please Login or Register to view this content.
Please post a sample workbook with some typical but non-sensitive data and the code.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hello Dgp2012,
Array Formulas can take some time to calculate. VBA will not wait until these calculations are done. Perhaps adding a delay to code will help.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks