Skip part of code depending on cell value

Hi

I have some code where I'd like to skip a section depending on a cell value, in regular English this is what I mean....



CODE
CODE
CODE
CODE
If Sheet1 Cell A5 = 5 then JUMP TO "HERE"
CODE
CODE
CODE
CODE
HERE
CODE
CODE
CODE
CODE
CODE


So basically if cell A5 is 5, then miss the code between "HERE and "HERE". If A5 does not equal 5 then run all the code.

Any ideas?
Thanks :D

Please Login or Register  to view this content.

Hi,

Thanks :D
How do I properly reference the cell and insert an If statement... something like?


Sheets(Sheet1).Range.("A5") = 5

And how do I define "here" as a something I can use?

Thanks

1. If Worksheet("Sheet1").Range("A5") = 5 then goto here.

2. you can use almost any reference in the goto statement as long as you add a colon ( to the same reference further down your code. you do not need to declare it as you would a variable.

That's great, thanks!

I am new to forums and let me know if I need to start a new Post.
I have something very similar and need some help.

Hi,
I am new to forums and let me know if I need to start a new Post.
I have something very similar and need some help.