Hi , HaHoBe
I change the private sub to public in the module and worked! thanks HaHoBe
Just when thought I'm done i found myself stuck again. guess something small but wanted to change the criteria range from lower then 0 to about lower then 5 which = to 120 hours.
which was easy enough but now it picks up all the 0 in my list and sending email , i received like 400 warning emails because of that haha.
so i need to get it to ignore "0" or create IF functions for "IF the cell in column "G" = 0 , which contains project code,then ignore adjacent F cell)" then should move on with the list ?
I tried adding
it seams to work but i think will probably only work if there word "Text" in the cell? how do i specify that column G should have text not = 0 before runs skrip?
Edwin
Bookmarks