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.
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.
Bookmarks