LinkBack URL
About LinkBacks
Below is the code i use i need a check to see if column i is greater than 5, if it is then send the email if not do not send the email
Please Login or Register to view this content.
Below is the code i use i need a check to see if column i is greater than 5, if it is then send the email if not do not send the email
Please Login or Register to view this content.
Last edited by AliGW; 08-03-2023 at 07:48 AM. Reason: Code tags added - please review the forum rules.
Doesn't column I contain an email address?Please Login or Register to view this content.
Administrative Note:
Please review the forum rules (code tags & cross-posting).
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/
(Note: this requirement is not optional. As yo uare new here, I'll do it for you this time: https://www.mrexcel.com/board/thread...n-i-5.1242468/)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
which column contains the value that needs to be greater than 5
something like if sh.Range("your column" & i).Value > 5 then
Please Login or Register to view this content.
Thank you works as intended
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks