Search:

Type: Posts; User: Richard Schollar; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.57 seconds.

  1. Replies
    2
    Views
    72

    Re: Save Workspace

    Thanks Steve - I literally had not used in, noted its existence or spent any time considering Workspaces prior to 18 months ago - then I realised just how flipping useful they were when you might...
  2. Replies
    2
    Views
    72

    Save Workspace

    I realise I am a little out of date Excel-wise as I have spent the last year and a half on Excel 2010 and found the Save Workspace feature incredibly useful (this after **** near 20 years of never...
  3. Replies
    3
    Views
    286

    Re: Linked data sources

    I love you!

    Brilliant - did what I wanted (although ended up using the SourceTableName property rather than the connection string).

    It's been 10 years since I last used DAO. I feel old...
    ...
  4. Replies
    3
    Views
    286

    Linked data sources

    Howdy

    I have been provided with an Access database (mdb format) which links to - I believe - many underlying SQL Svr tables/views/queries in at least one (possibly more) SQL Svr tables.

    My...
  5. Replies
    2
    Views
    189

    Table referencing

    Using: Excel 2013 64bit

    I have been sent a worksheet by a colleague that contains two tables that in Name Manager are defined as follows:

    Name: S.08.02.x.01
    Scope: Workbook
    Refers to:...
  6. Happy Birthday Rorya!!!!!!!!!!!!!!!!!!!!!!!

    It's Rory's birthday today so everyone please joining me in wishing the old fella a great birthday!!!
  7. Replies
    12
    Views
    3,676

    Jon von der Heyden's birthday!!!

    Happy Birthday for tomorrow Jon!!!

    What is it now? 40 years old!

    This forum is a much better place with you my friend!
  8. Replies
    8
    Views
    2,409

    Re: RTRIM by formula?

    Hi Rory

    It's good but my data is in B1 not A1. Please provide a working formula.


    :diablo:

    Seriously, thanks very much
  9. Replies
    8
    Views
    2,409

    RTRIM by formula?

    Hi

    How could you perform an RTRIM by formula (not VBA) - so remove trailing spaces but not trim any multiple spaces at front/in the middle?
  10. Issue with 2 windows being open (of same workbook)

    Using: Excel 2013 64 bit

    I have a relatively complex workbook open utilising multiple sheets, VBA, Tables and PowerPivot referencing those tables.

    Because of the multi sheet structure it makes...
  11. Re: October Challenge Discussion - Best Diversion

    I agree - I would demand a full refund of your membership fees! Oh, wait...
  12. Happy Birthday Bill Jelen (aka Mr Excel)!

    It's Bill's birthday today so I'd like to say Happy Birthday and I hope it's a good 'un!

    :beerchug:
  13. Replies
    10
    Views
    100,672

    Re: Where is Greg Truby?

    Hmmphhh! :mad2:
  14. Re: How do you check for existence of Autofilter in a Table?

    You too - I must arrange an evening pass from the wife for sometime soon :beerchug:
  15. Re: How do you check for existence of Autofilter in a Table?

    Hi Rory

    Perfect - thank you, that was exactly what I needed. Filter arrows weren't visible.
  16. Re: How do you check for existence of Autofilter in a Table?

    Hi Rick

    That is definitely bugging out for me (Run time error '91': Object variable or With block variable not set).

    I am using Excel 2013 64bit on Windows7.
  17. How do you check for existence of Autofilter in a Table?

    If I have an Excel Table, and want to check if Autofilter is applied (to the Table), how do I go about it?

    I have tried:


    If Activesheet.ListObjects(1).Autofilter.FilterMode Then ...

    which...
  18. Replies
    2
    Views
    584

    Re: Free Excel Addins

    Date fixing implies it isn't simply a formatting issue.

    Data>TextToColumns>Next>Next>choose Import Format of Date>DMY (or MDY)>Finish

    should correctly convert text dates to real dates.
  19. Replies
    6
    Views
    675

    Re: Free lancing

    Blimey, from the thread title I had incorrectly assumed somebody had a bad case of boils :diablo:
  20. Re: Excel VBA Run-time error '13' Type mismatch

    Hi

    It's always much more difficult for members to comment when the full code is not given (so please do post the entire Sub).

    However, you have potential issues around the possible values of...
  21. Replies
    2
    Views
    473

    Re: Happy Birthday Bill Jelen

    Enjoy the day Bill. Seen any alligators down Florida way?

    Happy Birthday!

    :beerchug:
  22. Replies
    22
    Views
    2,277

    Re: Most frequently used piece of VBA

    I often find myself having a set of values (more than 2) that I need to filter a large dataset on. So I frequently make use off the Immediate Window with two lines of code:


    'select the values...
  23. Replies
    12
    Views
    940

    Happy Birthday Rory!!

    Please join me in congratulating Rory on reaching another birthday without succumbing to liver disease!

    Congratulations Rory!!!

    :beerchug:
  24. Replies
    8
    Views
    268

    Re: Creating pivot tables VBA

    I recommend outsourcing your coding needs to a generous friend - it worked for me!
  25. Re: counting how many different numbers in a row

    You're welcome :)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4