Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    5
    Views
    307

    Re: Recommend a spreadsheet

    Well, there's a saying here that asking someone to recommend a course of action likely to be non beneficial to themselves would be like expecting Turkeys to vote for Christmas (when turkey is the...
  2. Replies
    5
    Views
    307

    Re: Recommend a spreadsheet

    If he's serious, he should get a consultant to do it...

    But Turkeys & Christmas springs to mind :laugh:
  3. Replies
    19
    Views
    799

    Re: Tricky VLOOKUP Question?

    Or

    =DSUM(A1:B13,"Value",E1:E2)

    Where A1:B13 is your data table

    E1 contains the value "Product" (without quotes)
    E2 contains the value "A" (without quotes)
  4. Replies
    50
    Views
    3,257

    Re: Why MrExcel is like Hitch Hiking

    Because i'm stoooopid

    Started telling the story of the two Birminghams and then realised it had been linkedto already earlier in the post :)
  5. Replies
    50
    Views
    3,257

    Re: Why MrExcel is like Hitch Hiking

    oops
  6. Re: Clearcontents in a cell with a commandbutton

    Try this


    For x = 0 To ListBox1.ListCount - 1
    If ListBox1.Selected(x) = True Then
    With Worksheets("XWorksheet").Range("A2:A30")
    .Cells(x + 1).ClearContents
    End With

    End If
  7. Replies
    118
    Views
    13,806

    Bill, Try the Universities - they are usually...

    Bill,

    Try the Universities - they are usually more reasonable - there are 2 in Birmingham, of which Aston is probably better located being nearer the city centre...

    some links
    ...
  8. Try this Sub addnewbook() Dim NewBook As...

    Try this


    Sub addnewbook()
    Dim NewBook As Workbook

    Set NewBook = Workbooks.Add

    With NewBook
    .Worksheets("Sheet1").Name = "Something Else"
  9. Replies
    118
    Views
    13,806

    Birmingham

    Yep,

    Whether I come to the seminar or not, I'll certainly be around for a "night before" few beers. Richie Sills is still around in Birmingham too (Richie(UK)) - we can rustle a few people up for...
  10. Replies
    1
    Views
    416

    Well, I would do this by passing a SQL Query to...

    Well, I would do this by passing a SQL Query to your MySQL Database.

    You will need to connect using a connection string such as


    Driver={MySQL ODBC 3.51...
  11. Replies
    2
    Views
    967

    Some XL/VBA "Gurus" gain work almost exclusively...

    Some XL/VBA "Gurus" gain work almost exclusively in a consultancy role (though there are only a few who can make a living from XL/VBA consulting alone). Therefore many have other programming...
  12. Replies
    9
    Views
    1,023

    Poll: LOL Kristy :lol: :-D :outtahere:

    LOL Kristy :lol: :-D :outtahere:
  13. Replies
    16
    Views
    1,643

    Poll: Hiya Greg The emoticons I would suggest are ...

    Hiya Greg

    The emoticons I would suggest are

    :lol: :x :o :-D :huh: :!:

    Office 12 evokes all of the above emotions... but the more I use it the more I like it... in fact for the first...
  14. Replies
    37
    Views
    7,566

    Yes, i guess on balance it has. But actually...

    Yes, i guess on balance it has.

    But actually it was probably discovering the incredible learning resources available on the .net that has helped me to advance my career, not just specifically...
  15. Replies
    16
    Views
    1,643

    Poll: There's a 60 day trial version available (at...

    There's a 60 day trial version available (at least here in the UK) for just that purpose

    http://ukireland.trymicrosoftoffice.com/
  16. Replies
    16
    Views
    1,643

    Poll: Yes I already have. I love it. Sure it has...

    Yes I already have.

    I love it. Sure it has bugs but it's the future and it aint going
    to go away. We had already committed to SQL 2005 BI toolkit
    for our main server set up so MOSS 2007 & Office...
  17. Replies
    65
    Views
    8,779

    WillR Will Riley I just hit "JOIN"...

    WillR


    Will Riley

    I just hit "JOIN" before I finished typing my name I guess :huh:
  18. Replies
    6
    Views
    773

    Hi Greg, I have sent you a PM. :-D

    Hi Greg,

    I have sent you a PM. :-D
  19. Replies
    6
    Views
    773

    You could do this if you were using something...

    You could do this if you were using something like Sharepoint - but only one user at a time would be able to have the file open & use the macros as with normal XL behaviour (AFAIK)

    And all users...
  20. Replies
    21
    Views
    3,214

    As well as the other stuff listed here I used...

    As well as the other stuff listed here

    I used Excel as a database to chart my daughter's milk intake when she was born up until she was weaned - it was a cool little application and what made it...
  21. Replies
    2
    Views
    481

    You can use the datalinks wizard ...

    You can use the datalinks wizard


    '*************************************************************************
    '* The following code enables the user to get a valid connection string *...
  22. Replies
    3
    Views
    461

    I'd say your assumption was pretty much spot on....

    I'd say your assumption was pretty much spot on. :)
  23. Replies
    3
    Views
    282

    Have you tried ...

    Have you tried



    Sheets("B").Range("A6:B6").Font.ColorIndex = 3
  24. Replies
    7
    Views
    437

    how about =SUMPRODUCT((YEAR('Powers Final...

    how about


    =SUMPRODUCT((YEAR('Powers Final '!$E$32:$E$600)=YEAR('Summary Final '!D62))*'Powers Final '!$N$32:$N$600)
  25. Replies
    2
    Views
    339

    Wrap the code in Application.DisplayAlerts =...

    Wrap the code in


    Application.DisplayAlerts = False
    'code
    Application.DisplayAlerts = True
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4