Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    2
    Views
    81

    Hi Zeddy Thanks for the help, match...

    Hi Zeddy

    Thanks for the help, match appreciated


    Howard
  2. Replies
    2
    Views
    81

    Formula or Macro to Match Values

    I have debit values in Col B & credit values in Col C

    I would like to set up a formula or macro to match the values that are the same and to delete the rows where these match
  3. Replies
    4
    Views
    269

    Thanks for the info Guys

    Thanks for the info Guys
  4. Replies
    4
    Views
    269

    Message Help us protect your account

    I have Windows 8 operating system

    When I tried logging into Skype, I get the following message

    Help us protect your account

    We detected something unusual and need to verify your account....
  5. Replies
    0
    Views
    395

    Increasing the number of libraries

    I have several libraries created on Windows 7. However, when trying to create a new library nothing happends. I guess I have reached the maximum level. Is there a way to increase the number of...
  6. Thanks Maud, never thought of this. Have amended...

    Thanks Maud, never thought of this. Have amended code and it works perfectly
  7. 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 ...
  8. Hi Guys Thanks for your input, much appreciated

    Hi Guys

    Thanks for your input, much appreciated
  9. 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
  10. 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
  11. 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
  12. 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...
  13. 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...
  14. Thanks for the info Maud, however the message box...

    Thanks for the info Maud, however the message box with the OK button still appears
  15. 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"...
  16. Replies
    7
    Views
    310

    Thanks for your input dguillett

    Thanks for your input dguillett
  17. Replies
    7
    Views
    310

    Hi Maud Thanks for the help and your input

    Hi Maud

    Thanks for the help and your input
  18. Replies
    7
    Views
    310

    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...
  19. Thread: Library

    by HowardC
    Replies
    2
    Views
    249

    Thanks for the reply. Much appreciated

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

    Thanks for the useful link, much appreciated
  21. 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...
  22. Replies
    5
    Views
    241

    Thanks for the help chaps

    Thanks for the help chaps
  23. Replies
    5
    Views
    241

    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
  24. Replies
    3
    Views
    183

    Thanks for the advice

    Thanks for the advice
  25. Replies
    3
    Views
    183

    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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4