Jump to content

Why is my Macro skipping the If statement completely?

- - - - -

This topic has been archived. This means that you cannot reply to this topic.
3 replies to this topic

#1
Mishal

Mishal

    Newbie

  • Members
  • Pip
  • 2 posts
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!!!!!!!!!!!!!!

#2
so1i

so1i

    Programming Professional

  • Members
  • PipPipPipPipPip
  • 312 posts
Sure, send along the code. :)

#3
Mishal

Mishal

    Newbie

  • Members
  • Pip
  • 2 posts
mail address?

#4
so1i

so1i

    Programming Professional

  • Members
  • PipPipPipPipPip
  • 312 posts
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 :)

Attached Files