Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Hi Zeddy Thanks for the help, much appreciated

    Hi Zeddy

    Thanks for the help, much appreciated
  2. Formula to compute net amount per control

    I need to compute the net amount in Col I based on unique controls in Col E and the nett amounts of the debit values less the credit values

    I have used a simple formula to do this, but need a...
  3. Replies
    19
    Views
    850

    Thanks for your input Rory

    Thanks for your input Rory
  4. Replies
    19
    Views
    850

    Hi RG No problem

    Hi RG

    No problem
  5. Replies
    19
    Views
    850

    Thanks Zeddy & Madibe for your input Te code...

    Thanks Zeddy & Madibe for your input

    Te code works perfectly

    Maud the formulas must be in Column B.
  6. Replies
    19
    Views
    850

    Hi Maud I have set up code to change the value...

    Hi Maud

    I have set up code to change the value based on the month selection which works fine, but have had to manually amend the cell references-see below

    Is there a way to incement the cell...
  7. Replies
    19
    Views
    850

    Thanks Maud It has now come back to me on how...

    Thanks Maud

    It has now come back to me on how to set this up. I have set up the months on the same spreadsheet (called months) and linked it to the combo box and changed the properties in...
  8. Replies
    19
    Views
    850

    Hi Maud This is perfect I have not set up a...

    Hi Maud

    This is perfect

    I have not set up a combobox for a very long time so a bit rusty. Please explain to me how to set up the combobox in your example and linking to the months

    Howard
  9. Replies
    19
    Views
    850

    Hi RG Thanks for your input I cannot open...

    Hi RG

    Thanks for your input


    I cannot open up your attachment. I comes up with Invalid attachment specified.
  10. Replies
    19
    Views
    850

    Using Indirect Function in Sum Formula

    I have a sum formula referring to a cells to add data on various sheets for eg =sum(Oct:Mar!B6) ,=sum(Oct:Mar!B7) etc

    I would like to use an indirect formula to refer to a month name from a drop...
  11. Replies
    4
    Views
    140

    Thanks very much. Code works perfectly

    Thanks very much. Code works perfectly
  12. Replies
    4
    Views
    140

    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
  13. Replies
    4
    Views
    140

    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...
  14. Replies
    3
    Views
    341

    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
  15. Replies
    2
    Views
    125

    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
  16. Replies
    2
    Views
    125

    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
    ...
  17. Replies
    3
    Views
    341

    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...
  18. Replies
    3
    Views
    341

    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...
  19. Replies
    17
    Views
    1,102

    Hi Don Thanks for your input, much appreciated

    Hi Don

    Thanks for your input, much appreciated
  20. Replies
    17
    Views
    1,102

    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...
  21. Replies
    17
    Views
    1,102

    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
  22. Replies
    17
    Views
    1,102

    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
  23. Replies
    17
    Views
    1,102

    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...
  24. Replies
    17
    Views
    1,102

    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
  25. Replies
    17
    Views
    1,102

    Hi Martin Thanks for the advice

    Hi Martin

    Thanks for the advice
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4