Papayamoo
10-06-2011, 02:28 PM
Hi, hope this is a quick question but I'm a VBA newbie so here goes.
Trying to format certain cells in my worksheet base the value inside. However, not all of the values I'm looking for is in every worksheet I need to format. So for example, if I'm trying to format cells with the word "banana" but some sheets doesn't have "banana" then it kills the macro and stops looking for the next value.
I thought that I could build an if statement around it but it's not working out too well. What I'm using is Cells.Find(What:="banana"....).Activate. Is this workable or do I need to do something totally different? Any help is greatly appreciated.
M.Yu
Trying to format certain cells in my worksheet base the value inside. However, not all of the values I'm looking for is in every worksheet I need to format. So for example, if I'm trying to format cells with the word "banana" but some sheets doesn't have "banana" then it kills the macro and stops looking for the next value.
I thought that I could build an if statement around it but it's not working out too well. What I'm using is Cells.Find(What:="banana"....).Activate. Is this workable or do I need to do something totally different? Any help is greatly appreciated.
M.Yu