Macro to run on specific

[stilgar]

I have some macro's which i need run in a loop only if cell "d36" contains text of any sort.

i already have a set of macro's running on a timer of 5 secs but i'll need these macro's to do the same only if cell d36 contains text. the text will be a part number of some sort depending on what was selected.

this might not be the best way of making it work but i'm not sure of how else to do it.

any idea's?

 

[John Davis]

I have some macro's which i need run in a loop only if cell "d36" contains text of any sort.

i already have a set of macro's running on a timer of 5 secs but i'll need these macro's to do the same only if cell d36 contains text. the text will be a part number of some sort depending on what was selected.

this might not be the best way of making it work but i'm not sure of how else to do it.

any idea's?

Maybe:

Sub Stilgar

If IsNumeric(Range("D36")) = False Then Call YOUR OTHER MACRO'S

End Sub

 

[stilgar]

perfect! legand! thanks mate

 

[John Davis]

perfect! legand! thanks mate

You're welcome. Glad I could help.