Hi Gurus
I thought I knew it but it is strange I am getting this error.
I get Runtime error 424 when macro reaches "If ws.Cells(i, 10).Value = BankEntry Then" Line.
Please Login or Register to view this content.
I tried Integer, Long, String. Nothing works
When I hover mouse to "BankEntry" while running macro, it shows correct Value.
Any clue?
Last edited by caabdul; 01-20-2018 at 07:24 PM.
You say you tried Integer....did you dim i and j as integer?
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
I suspect you just need to remove ws. fromPlease Login or Register to view this content.
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
gmr4evr1, you are saying write, I missed defining some data types
TMS, You Rock
One small issue
I have Dim BankEntry as Integer.
When I run it on 99.99, the "BankEntry = Cells(j, 9).Value", it stores it as 100 and when I compare it with 99.99, it does not equal in Boolean.
2 things I would try
1 - Dim BankEntry as Range
2 - Check the format of where the 100 is to make sure it is formatted as number with 2 decimal places.
Try:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks