Code:
For Each cell In Ash.Columns("b").Cells.SpecialCells(xlCellTypeConstants)
nkf53
Last Activity: Jul 1 '10, 06:38 AM
Joined: Jun 9 '10
Location:
-
Logic statement help
Sorry for the bother again, I've been continuing improving what I made, and was just now trying to make a if then statement work by putting it before this. Such as If Ash.columns("e" )> ash.columns("F) " Then (the following will occur. I'm not even sure if this is possible. But Thanks for even taking the time to read this.
... -
Yea I figured that out >.>, thanks for the help as always i figured out a way to make it work :) -
I'm an idiot, I figured out I could basically do a email setup by setting it to a yes no column, then doing a basic if then statement using yes, no. Thanks for the help as always!Leave a comment:
-
Coding Issue VB, Greater than
Just trying to figure out why my code isn't working, Could anyone help point out some flaws? or give a possible solution?
Option Explicit
Code:Sub box() If ActiveSheet.Range("f1:f1000").Select > ActiveSheet.Range("g1:g1000").Select Then msgbox ("Min quantity not met") Else End If Exit Sub End Sub -
So I changed it up
I decided to make it much simpler, but is there something wrong with my logic statements here?
...Code:Sub msgbox() Dim Source As Range If ActiveSheet.Range("f1:f1000").Select > ActiveSheet.Range("g1:g1000").Select Then msgbox ("Min Quantity order not met, Please Check") End If Exit Sub End SLeave a comment:
-
So far this what i've got as a skeleton
My Brains getting fried right now -.-
...Code:Option Explicit Sub example() Dim cell As Range Dim rng As Range Dim Ash As Worksheet Set Ash = ActiveSheet Dim x As Integer If Ash.Columns("g").cell.Value >= Ash.Columns("f").cell.ValueLeave a comment:
-
Thanks, I think I'm going to just settle it as 2 separate boxes where one is to check the qunantity and the last one is to send them all out. Much appreciated! now wish me luck on coding it lolLeave a comment:
-
If Then statement help
Ok so I'm going to try again
I know i need an if then statement, but I can't figure this out and have been stumped for a few days.
...Code:Option Explicit 'Needs Module 2 to set definitions for RAngeHTM so, both moduels needed Sub Send_Row() Dim OutApp As Object Dim OutMail As Object Dim cell As Range Dim rng As Range Dim Ash As WorksheetLast edited by Niheel; Jun 10 '10, 03:31 AM. Reason: When showing code for your question, enclose it in code tags. [code] . . .[/code]Leave a comment:
-
setting criteria on automating email with if then else
I've joined this thread hoping to expand my knowledge on visual basic and gain some understanding.
Currently I've been just learning off of other people's codes and I've been just trying to figure out to do something.
I've been trying to add a macro to my current one which would send an email out based upon a yes or no column. But my issue is What happens if i want to have an if then statement that correlates to another column... -
Hi Sorry I'm new and new to visual basic just some qustions
sry i shoulda posted this in it
No activity results to display
Leave a comment: