Run macro is cell range is not blank

[marcosis]

I have a button that triggers a set of macros, one calling the next one at the end of each one. I couldnt figure out how to only trigger the particulary one if it wasnt blank so i made a new sub and pointed the previous one to this instead, only calling the next if this range isnt blank, but im getting a type mismatch error.

Please Login or Register  to view this content.

I was testing this range so that i could check if the code worked at all because i actually want it to only run if the ranges
B5:F12 B16:F25 B29:F31 B35:F38 B43:F53 B58:F69 on the sheet "STOCK" contain any values. So if any of the cells in them ranges have something in run the macro.

[dotchiejack]

Hi,

Please Login or Register  to view this content.

[marcosis]

Hi,

Please Login or Register  to view this content.

Christ you guys are good!

Works perfectly, although you knew that because its pretty simple to you! haha

By the way, knowing things like this, was it something you studied at college, or are you self taught or have you done online courses.

Or is it a mix of all of the above?

[dotchiejack]

Hi, glad to help.
self taught and courses from my employer.
Have a nice day.

[marcosis]

Courses from your employer?

The reason i asked is that my company has said that whatever courses i want to do, theyd pay for, so i was just going to use things like Udemy etc.

Last question. Was yours for a qualification, or was it from sites like Udemy, thats just an online course?

Thanks again!