Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    4
    Views
    46

    Thanks very much. Code works perfectly

    Thanks very much. Code works perfectly
  2. Replies
    4
    Views
    46

    Thanks for your help I have amended as...

    Thanks for your help

    I have amended as follows:


    Dim StrBodyAddr As String

    StrBodyAddr = Range("M3").Value
  3. Replies
    4
    Views
    46

    Linking Name in Code to cell address

    I have the following code below, which I want to link to a cell so that the name for e,g. Peter it can be changed in the cell as opposed to within the code



    StrBody:="<H3><R>Dear...
  4. Replies
    3
    Views
    105

    Hi Maud I managed to sort out the automatic...

    Hi Maud

    I managed to sort out the automatic saving of the file

    I went through the code and amended


    FixedFilePathName:="", _
    to
  5. Replies
    2
    Views
    63

    Hi Paul Thanks very much I just added...

    Hi Paul

    Thanks very much

    I just added statement to declare the variables

    It is working perfectly
  6. Replies
    2
    Views
    63

    Set email address in Cell

    I would like to amend my code below so that the email address/addresses can refer to a cell/s on sheet2

    My full code runs perfectly, but just need this change


    If FileName <> "" Then
    ...
  7. Replies
    3
    Views
    105

    Hi Maud Thanks for pointing this out. I have...

    Hi Maud

    Thanks for pointing this out. I have managed now to covert the ranges to PDF and to email this

    See my code below

    I would like both PDF files (two separate ranges), attached to the...
  8. Replies
    3
    Views
    105

    Email file in PDF

    I have the following code with I tried to adapt from to email selected ranges as a PDF file, but I get a compile error and the code below is highlighted


    FileName = RDB_Create_PDF



    Your...
  9. Replies
    17
    Views
    464

    Hi Don Thanks for your input, much appreciated

    Hi Don

    Thanks for your input, much appreciated
  10. Replies
    17
    Views
    464

    Hi Zeddy It is not ideal to have values at the...

    Hi Zeddy

    It is not ideal to have values at the end of a formula, but from time to time, I'm informed to adjust a commission amount either up or down. I'm going to use RG's advise in post #4 as it...
  11. Replies
    17
    Views
    464

    Hi Maud Great idea to add 3rd column...

    Hi Maud

    Great idea to add 3rd column referencing the Cell/s that use the formula for referencing
  12. Replies
    17
    Views
    464

    Thanks for your code Zeddy. If I need your code...

    Thanks for your code Zeddy. If I need your code to ignore last two sheets, do I amend as follows?


    If sh.Index > 1 And sh.Index < Sheets.Count -1 Then
  13. Replies
    17
    Views
    464

    Hi Don Thanks for your code. What I was...

    Hi Don

    Thanks for your code. What I was looking for was to remove all values in my formulas for eg +B205/2-2000, =IF(B182<0,0,Commission8(B182+B181))+7250 etc

    I like RG's idea of not hardcoding...
  14. Replies
    17
    Views
    464

    Hi RG Thanks for your input. I like your idea...

    Hi RG

    Thanks for your input. I like your idea very much and will implement this
  15. Replies
    17
    Views
    464

    Hi Martin Thanks for the advice

    Hi Martin

    Thanks for the advice
  16. Replies
    17
    Views
    464

    Macro to remove values in formulas

    From time to time I need to amend formulas manually by by adding or subtracting a value when making adjustments

    At the beginning of each year, I need to manually remove all the values the appear...
  17. Replies
    2
    Views
    218

    Hi Kweaver Thanks for the help, much...

    Hi Kweaver

    Thanks for the help, much appreciated
  18. Replies
    2
    Views
    218

    Using indirect formula within Vlookup

    I have a workbook where I use a vlookup which looks up a value in another workbook

    I want to use an indirect formula so that I can change the year when the file name year changes from say...
  19. Thanks for the info. I now fully understand the...

    Thanks for the info. I now fully understand the logic
  20. Thanks for the help, much appreciated Please...

    Thanks for the help, much appreciated

    Please explain the following

    1) having two commas ,, after .... November, December),,match
    2) why + 2 after MATCH(A6,'Leave Register'!$C$2:$D$2)+2 ? ...
  21. Formula error Sumproduct , combined wth Index and match

    I am trying to determine which employee/employees are on leave in the current month, but get an incorrect solution-see F6
  22. Hi Don Thanks for the code. It works perfectly

    Hi Don

    Thanks for the code. It works perfectly
  23. Hi Maudibe Thanks for your input

    Hi Maudibe


    Thanks for your input
  24. Hi Maud This works perfectly. Does this use...

    Hi Maud

    This works perfectly. Does this use quite a bit of resources? When I type in an "a" a second or third time , I need to close Excel and then re-open and it works
  25. Hi Maudibe Thanks very much. Your code is what...

    Hi Maudibe

    Thanks very much. Your code is what I am looking for. However, if the user has made a mistake, he/she must be able to remove the ticks
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4