you are right Mumps.thank you!
Posts by zois
-
-
hi,i have this code for checking $I$1 for two certain values ("live" and "z") and do the precedures
Code
Display MorePrivate Sub Worksheet_Change(ByVal Target As Excel.Range) If Not IsNumeric(Target) And Target.Address = "$I$1" Then Select Case Target.Value Case "live" Call testup1 Call UpdateData Case "z" Call StopButton_Click Call StopButton_Click2 End Select End If End Sub
the problem is that cell $I$1 has formulaand the code doesn't work.if i put these values manualy it works fine.what should i change?i am stuck
-
Re: $35 vba code for sending email with specific columns
so ger,the job is done i run the code lot of times and works like i want.
one question,if i want to send me mail when some other columns take value,not G,J (lets say Q and T), just replace the G and J in code?
ok nothing more thank you very much! give me the details to pay you. -
Re: $35 vba code for sending email with specific columns
hi ger,yes you have right about the its hard to understand my requirements obviously is the English language which prevents me to explain exactly,anyway you got the point,the code works in every data refresh! sending me separate mails for each cell!
have two last issues:
The first,when the cells in G or J going blank send me mail i don't want to send me mail if the cells going blank( i want only for value change or for a new value).
And the second, when the cells in G change sending 2 mails one for G and one for J,i want one mail only for G (and not if cells goes blank)
can you do something about that? -
Re: $35 vba code for sending email with specific columns
My fault,i forgot to say i want the macro run automatically. this code work with a little problem, send me one mail for the values in G and another one with values in J,with these conditions if a value(in cell G4 for example)disappears and later this cell contains value will send me email with all values in G! i want one mail for each cell,if G4 contains any value OR if value in G4 change send me email...but not with the other cells in G!
-
Re: $35 vba code for sending email with specific columns
hi,do you mean how often i ll refresh the data? the data is from external source i have set refresh every 10 min.but the values wouldn't change so often,would change 1 or 2 times/day
about the time for the project...Thursday it would be ok.
would you take a look at this? -
hi,this is a part of my workbook
[ATTACH=CONFIG]63973[/ATTACH]
i want to make a macro that send me two emails,one for the values in column G and one for the values in column J.For column G:if a cell in G has value send a mail in my email account with columns C, D, E, G,and the word "today".
(example, for cell G4 i want to send this email: 5 kelly £410 3350,00% today)For column J:if a cell in J has value send a mail in my email account with columns C, D, E, J,and the word "today".
(example, for cell I4 i want to send this email: 5 kelly £410 18 today)the values in G and J will change or disappear according to the criteria in the formulas.
In the case that the values in G and J disappear and the next time appear the same value,i want to send again a mail with the existing value
In the case that the values in G and J change i want again a mail with the existing value.for any clarifications,please tell me!
i have pay the 10% in "[email protected]"[/email] (Unique Transaction ID # 48D32848P0681700T)
-
Re: auto copy paste cell if has any value-vba
yes works fine,thank you very much!!
-
i use this code to copy the values from Q:Q to V:V,
Code
Display MoreSub OneColumn() Range("Q:Q").Select Selection.Copy Range("V:V").Select ActiveSheet.Paste Application.CutCopyMode = False End Sub
but i want the macro running automatically,(if Q1 has value copy in V1).......,
and another problem is that the cells in Q:Q contain a formula. i don't want to copy the formula but only the values.
how can i do that?