Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    0
    Views
    100

    View Post

    When I run the following code, the watch window reports the following:
    Watch : : CurrentRegion : <Expression not defined in context> : Empty : Splitx.TestCode

    Sub TestCode()
    Dim arr As...
  2. Re: format dd/mm/yyyy date as text in VBA without US conversion

    I have been trying to this for yonks and have never found anything useful on any Excel forum. Today,I tried something different and it appears to work.

    This was my problem:
    txtReviewDate =...
  3. Replies
    0
    Views
    317

    Date calculations in Excel 2016 VBA

    ' The following block of code calculates the service user's age and turns on the 'Child' radio button _
    if the service user is under 18 years of age.
    ' This works fine in Excel 2007 but crashes...
  4. Replies
    2
    Views
    216

    Re: Need help to find record

    And how does this help me?

    What is the point of answering "Without using VBA", when my query specifically asked for a VBA solution?

    How do you propose that I use your 'solution' for mail merge?...
  5. Replies
    2
    Views
    216

    Need help to find record

    I have a rather large Excel spreadsheet that I use for mail merges, etc.,

    I also use it to get information from individual records for forms, letters, et al.

    I would like to be able go...
  6. Re: format dd/mm/yyyy date as text in VBA without US conversion

    I do, and it doesn't work
  7. Re: format dd/mm/yyyy date as text in VBA without US conversion

    Formatting the date in the Word document does absolutely nothing. Obviously Microsoft care little for those us that use their software and use dates in the way that they were designed, not the...
  8. Replies
    0
    Views
    326

    Merge direct from Excel

    I merge several letters per day, from a database that I have in Excel. For each merge, I have to create a new Word document from a template. To do this I go to the mailings tab; Click on Edit the...
  9. Replies
    6
    Views
    464

    Re: Users locking spreadsheet

    I cannot see that anywhere in Word 2007. I did F12 to get the save as dialog box but the only things on the top right hand side are:
    The back buttons
    The delete button (greyed out)
    New Folder...
  10. Replies
    13
    Views
    46,372

    Re: VBA date problem.

    Actually the English spellings are the correct ones and make much more sense. You seem to prefer a mixture as you have spelt colour the English (correct) way and center the American (incorrect) way.
  11. Replies
    6
    Views
    464

    Re: Users locking spreadsheet

    Thanks for the suggestion, Phanmore, but I have already tried that and it does not solve my problem it merely stops him from updating the spreadsheet but the spreadsheet remains locked for use by...
  12. Replies
    6
    Views
    464

    Re: Users locking spreadsheet

    Thanks for the enormous effort put in by so many people to offer suggestions!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!:crash::crash::crash::crash:
  13. Replies
    8
    Views
    469

    Re: Mail Merge Question

    You are getting about as many replies as I am to mine then :(
  14. Replies
    6
    Views
    464

    Users locking spreadsheet

    I have a spreadsheet that I use for merging for details to word forms on a regular basis.

    My problem is that a colleague often opens the spreadsheet to obtain data and this then stops me from...
  15. Re: Using Case statement with True and False keywords

    Many thanks, Richard, this worked like a dream. :)
  16. Using Case statement with True and False keywords

    I have an Excel 'database' that I need to update some records on but ubfortunately the Select Case statement is not working as I expected it to.

    This the code that I have:

    Select Case cbVI2...
  17. Thread: Ashgaroth

    by ashgaroth
    Replies
    3
    Views
    379

    Re: Ashgaroth

    I found the problem with this text.
    The first line of the code reads Columm1=0 instead of Column1=0, so it works now.

    Thanks Andrew for the link, this lokks good as it looks like it will help me...
  18. Thread: Ashgaroth

    by ashgaroth
    Replies
    3
    Views
    379

    Ashgaroth

    I am trying to sort a spreadsheet by 2 columns and putting the names in a combo box in alphabetical order. Unfortunately, I keep getting a <subscript out of range? error.

    This is the code that I...
Results 1 to 18 of 18