I have a VB Macro to compare data in an Excel spreadsheet and if the totals match up then it needs to delete the specified rows. It matches certain values and deletes but in some instances it skips the entire if statement. If i go through it step by step i can see it doing that. The values are majority decimal and i have converted any text from the cells into Double.
If anybody wants to try help me, please send me your email address and i will happily send you the workbook and code!
Please help me urgently!!!!!!!!!!!!!!
Why is my Macro skipping the If statement completely?
Started by Mishal, Mar 29 2010 10:47 PM
3 replies to this topic
#1
Posted 29 March 2010 - 10:47 PM
|
|
|
#2
Posted 29 March 2010 - 11:32 PM
Sure, send along the code. :)
#3
Posted 29 March 2010 - 11:33 PM
mail address?
#4
Posted 29 March 2010 - 11:47 PM
I'm afraid I will not have time to go through that code now... got to work :(
However I have uploaded it for you, so others might be able to have a go! Good luck, and if not I will have a look at it later on.
so1i :)
However I have uploaded it for you, so others might be able to have a go! Good luck, and if not I will have a look at it later on.
so1i :)


Sign In
Create Account

Back to top










