-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
certain cells
-
R
email only when a certain cell is populated
i have code to email when an address (several in dropdown list) which is housed in C51, but what i need is for this to only be active or be able to be sent when C50 is populated or at least contain certain text. would this be possible to do many thanks Private Sub CommandButton1_Click()Dim...- rooster05
- Thread
- certain cells email
- Replies: 7
- Forum: Excel Questions
-
B
How to link cells to Sheet names using a for loop
I'm trying to write some code that links to certain sheets if certain cells are clicked. My sheets are named "01", "02", "03", ... , "20", ... "XX". I'm hoping I can use some loops to reference the names of the sheets since they are in a number format, but "j", which is how I tried to link cell...- bellg
- Thread
- activate sheet with macro certain cells for loop iterate through rows sheet
- Replies: 3
- Forum: Excel Questions
-
C
Sum certain cells in different columns if the value is greater than zero
Hi Hope you can help me with this: I will give an example of what I want to do: A1 B1 C1 D1 E1 10 5 -5 20 10 So I want to sum the values only in the cells A1,C1,E1 but only the ones that are greater than zero, in this example the result should be 20. Any suggestions?? Thanks for...- chapysvp
- Thread
- certain cells sum certain cells
- Replies: 3
- Forum: Excel Questions
