LinkBack URL
About LinkBacks
hello
I have a macro that runs every hour and copy values to other cells and at the END of this macro running I need send an email every time if cell A1 or A2 has a value graeter than 2
someboy could help ?
hello
I have a macro that runs every hour and copy values to other cells and at the END of this macro running I need send an email every time if cell A1 or A2 has a value graeter than 2
someboy could help ?
Try this, placed in the sheet module
You will need to make your own changes to the e-mail addess & file name etc
Please Login or Register to view this content.Please Login or Register to view this content.
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
thank you Sean
so I have the email sent if one of these cell are graeter than 2
now I have other question : one or both are graeter than 2 and I need sent the email if either of these cell change although still graeter then 2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks