Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Thanks Maud, never thought of this. Have amended...

    Thanks Maud, never thought of this. Have amended code and it works perfectly
  2. Macro to copy data , except where = sum appears

    I have code to copy the Data in Col F (closing Balances) and to paste value these in Col C (Opening Balances) from row 3 onwards, except where the data contains an = sum formula. Where there is an ...
  3. Hi Guys Thanks for your input, much appreciated

    Hi Guys

    Thanks for your input, much appreciated
  4. Hi Maud Agree 100%. I'm going to use your...

    Hi Maud

    Agree 100%. I'm going to use your suggestion by placing an apostrophe in front of the section as mentioned by you
  5. Hi Maud The source files were developed by...

    Hi Maud

    The source files were developed by someone else so I did not want to amend their code, but I will ask the person to put an apostrophe in front of their code as this is the easiest way
  6. Thanks for pointing this out Maud. I was hoping...

    Thanks for pointing this out Maud. I was hoping that there may be another way. I will put an apostrophe in front of the message Box for all the files containing this message box statement
  7. Hi Guys Sorry for the confusion caused See...

    Hi Guys

    Sorry for the confusion caused

    See code below from original workbook which generates the message box in the source workbook. When calling this from the destination workbook, I want OK...
  8. Hi RG Thanks for the help. I used your code...

    Hi RG

    Thanks for the help. I used your code and called it from within my macro using application.run "DisplayMsgBox", but the message box still appears and I have to select the "OK" button to...
  9. Thanks for the info Maud, however the message box...

    Thanks for the info Maud, however the message box with the OK button still appears
  10. Code to automatically accept OK button without clicking it

    I have a macro that opens several files and activates a particular macro that brings up a message box that prompts the user the "OK" button

    I would like code to would automatically accept the "OK"...
  11. Replies
    7
    Views
    201

    Thanks for your input dguillett

    Thanks for your input dguillett
  12. Replies
    7
    Views
    201

    Hi Maud Thanks for the help and your input

    Hi Maud

    Thanks for the help and your input
  13. Replies
    7
    Views
    201

    Macro to open Files

    I have a spreadsheet, where I want to open all the files that are listed on sheet "workspace" in a folder called C:\Pull as well as the sub-folders

    I have tried to write code to do this -see code...
  14. Thread: Library

    by HowardC
    Replies
    2
    Views
    203

    Thanks for the reply. Much appreciated

    Thanks for the reply. Much appreciated
  15. Thanks for the useful link, much appreciated

    Thanks for the useful link, much appreciated
  16. Macro to copy data from one folder to another

    I have a workbook that contains a macro to copy files from one folder to another. I would like the code amended so that if the file in the destination folder already exits, it must not overwrite the...
  17. Replies
    5
    Views
    197

    Thanks for the help chaps

    Thanks for the help chaps
  18. Replies
    5
    Views
    197

    Set Default Folder when opening Files

    I am using Windows 8 and Office 2013

    I would like to know how to set a default folder when opening up files using Office 2013
  19. Replies
    3
    Views
    148

    Thanks for the advice

    Thanks for the advice
  20. Replies
    3
    Views
    148

    Managed to sort out my macro by breaking it down...

    Managed to sort out my macro by breaking it down into two sections


    Sub Print_Income_Statement()
    Sheets("Income Statement").Select

    Dim LastRow As Long
    LastRow = Sheets("Income...
  21. Replies
    3
    Views
    148

    Print Macro with seperate headers

    I have a macro to print a worksheet.

    When printing I want "revenue" Cell A2 to print in the header from A3 to A27 and "Costs" A28 to print in he header thereafter

    See Attached file containing...
  22. Thanks for the help , much appreciated

    Thanks for the help , much appreciated
  23. Replies
    1
    Views
    97

    [SOLVED] Just to let you know that I resolved the problem...

    Just to let you know that I resolved the problem

    A28 =SUM(SUMIFS(J:J,K:K,A28),(L:L,B28))
  24. Replies
    1
    Views
    97

    [SOLVED] Formula Problem

    I have tried to set up formula to add various categories in Cols K & L based on values in Col J and criteria in A28 onwards. I am using Excel 2010

    It would be appreciated if someone could assist
  25. Formula to add Data

    I would like to set up a formula to give add the totals in Col J, for the following categories

    Expense Input
    Internal Internal
    Output Sales


    See Sample Data attached
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4