Search:

Type: Posts; User: balla506; Keyword(s):

Search: Search took 0.00 seconds.

  1. [SOLVED] Kweaver, I got a #value error with this...

    Kweaver,

    I got a #value error with this formula. Thanks for the try though...may be something I am doing wrong.
  2. [SOLVED] This custom function will do the trick. Thanks. I...

    This custom function will do the trick. Thanks. I can't believe this one is not easier... but just one of the limitations I guess.
  3. [SOLVED] I am saying that Column N contains the actual...

    I am saying that Column N contains the actual text >0-1. I want to add the data in column T if it has this text. Basically I do not want the greater than or less than for the sum if. Just have the...
  4. [SOLVED] Sumif Formula that includes < or > sign in the criteria range cells not the actual < or > function

    Hi,

    I can't figure out how to have the sumif formula not use the greater than sign in the criteria but instead sum all the lines with >0 - 1 in it. not all the the data that is greater than 0-1......
  5. Replies
    4
    Views
    414

    This works beautifully!!! Thanks Maudibe.

    This works beautifully!!! Thanks Maudibe.
  6. Replies
    4
    Views
    414

    Add Signature to HTML email using VBA

    Can someone help me figure out how to add my standard signature to an email I create and send using VBA. I can get everything I want but that piece. Thanks.



    Sub testemail()

    If MsgBox("Send...
  7. Even Better. Thanks.

    Even Better. Thanks.
  8. Final code below. Thanks for all the help in...

    Final code below. Thanks for all the help in troubleshooting and fixing this.


    Sub Hardcode_days_values()

    Dim colNum As Long
    Dim cell As Range
  9. I am trying to look in column F6:AB6 so only one...

    I am trying to look in column F6:AB6 so only one row. How would this line of code go? I have tried messing with it multiple times to no avail. Thanks.
  10. Still popping a message that says object required...

    Still popping a message that says object required on the colnum= line


    Sub Hardcode_days_values()

    Dim colNum As Long
    Dim cell As Range
  11. I am erroring out again with the unable to get...

    I am erroring out again with the unable to get the match property of worksheetfunction class. I did a little more research and was wondering if it would be smarter to use the find function in VBA. I...
  12. This kicks a compile error saying Expected list...

    This kicks a compile error saying Expected list seperator or )...any ideas...I'm pretty sure my colnum= equation may not return the letter. Thanks.
    Sub Hardcode_days_values()

    Dim colNum As Long...
  13. Return Column Number to use in a Range VBA

    I am trying to get this to give me the column letter so that I can use it to hardcode based on a lookup. E5 contains the date I am looking for while columns f:AB is where I am looking for the date....
  14. Worked great. I actually had this at one time but...

    Worked great. I actually had this at one time but was just looking at it wrong. Thanks again.
  15. Excel formula to find same date as last year

    Hi,

    I cannot find a formula anywhere that will give me the excel serial number for the same date as last year (ie 7/1/2015 I want to return serial for 7/1/2014). I will be using this number for a...
  16. This did the trick. Thanks for your help on this.

    This did the trick. Thanks for your help on this.
  17. VBA Move a renamed sheet to a master sheet...

    The below code is what I am having issues with. Basically I want it to loop through a folder that I have set open every file rename 2 worksheets and then move these to the Dealer Planning rollup. The...
Results 1 to 17 of 17