Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    26
    Views
    7,593

    Re: FIFA World Cup Spreadsheet (free)

    Hi the Vuvuzelas are extremely loud and I have been wearing ear plugs to games to reduce the pain a bit. In the pubs, on the way to the ground, in the ground and afterwards they are just incessant. ...
  2. Replies
    26
    Views
    7,593

    Re: FIFA World Cup Spreadsheet (free)

    A bit low tech I know but I couldnt be sure how the scores would be displayed etc on web sites which makes it tough to o a web query so dcided to just update a page myself. I actually have a friend...
  3. Replies
    26
    Views
    7,593

    Re: FIFA World Cup Spreadsheet (free)

    Hi DK, I manually update a web page with scores. Im in Sth Africa at the WC so have been either at games or in the pub so havent had time to get to an Internet cafe until now.Should be Ok now.
    ...
  4. Replies
    26
    Views
    7,593

    Re: FIFA World Cup Spreadsheet (free)

    Hi all, fixed a couple of bugs in the spreadsheet. New version 1.3 can be downloaded from http://sites.google.com/site/paramorefifawc/download
  5. Replies
    26
    Views
    7,593

    Re: FIFA World Cup Spreadsheet (free)

    Thanks to all those who have downloaded my spreadsheet. Downloads now over 2,100 from 74 different countries.

    cheers,
    Graham
  6. Replies
    7
    Views
    572

    Re: disable copy paste

    How can you stop someone copying a file? You can't but you can restrict permissions at the O/S level.

    Can you protect the workbook and only have certain areas where they can type information and...
  7. Replies
    7
    Views
    572

    Re: disable copy paste

    From someone who's job was process improvement and re-engineering once upon a time this to me indicates deeper issues.

    The major issue appears to be either training and/or usability. I think you...
  8. Replies
    2
    Views
    338

    Re: symbols characters

    Hi, the OCR software will just read whatever is given to it. If the OCR is making mistakes seeing these symbols when they are other characters then you may have problems interpreting what they should...
  9. Replies
    2
    Views
    336

    Re: Extracting a string from mail address

    Hi, where D4 is the target cell..

    =RIGHT(D4,LEN(D4)-FIND("@",D4,1))
  10. Replies
    7
    Views
    572

    Re: disable copy paste

    Hi, stopping copying and pasting is a bit vague. Are you able to expand upon what your trying to achieve and perhaps people may have some ideas for you.

    You can protect sheets from editing...
  11. Replies
    2
    Views
    377

    Re: code to retrieve SQL table

    Hi, it looks like your connecting to a SQL Server db
    Provider=SQLOLEDB.1

    The ODBC file C:\Documents and Settings\m\My Documents\My Data Sources\Marketing.odc contains details on the connection...
  12. Replies
    5
    Views
    470

    Re: macro skips end sub

    Hi, the Change event happens when you select a value from the ComboBox - is this what you are doing? If your using ListFillRange then you indicate a range, Excel only supports this range if entered...
  13. Replies
    8
    Views
    714

    Re: Spliting worksheet into separate files

    Not surprised it doesn't work - cant see it in your code and I did say adjust to your needs. Anyways, as you are adding a page break after every item then why not simply add a counter and when you...
  14. Replies
    26
    Views
    7,593

    Re: FIFA World Cup Spreadsheet (free)

    Hi Richard, would be cool to see England do it. Let's hope you never have to face a penalty shootout! ;-)
  15. Replies
    26
    Views
    7,593

    FIFA World Cup Spreadsheet (free)

    For those interested in football [that's soccer to you Americans :-)] I have created a free spreadsheet which you can download here.

    Enjoy :-)

    regards,
    Graham
  16. Re: Vlookup substrings of a text,concatenate results into another string

    Hi, may not be what your after but perhaps?...



    Function MultiVLookup(rngLookupValues As Range, strValueDelimiter As String, rngLookupRange As Range, TargetColumn As Integer) As String
    Dim...
  17. Replies
    40
    Views
    5,407

    Re: Desperate, Catastrophic Error

    Yup thats exactly what I mean. Theres various ways to achieve this. Some places I've implemented a SQL server db that is regularly backed up with MS Access/Excel merely a way to work with the data...
  18. Replies
    40
    Views
    5,407

    Re: Desperate, Catastrophic Error

    That's great news. I'm only sorry we couldn't offer a "quick fix", but unfortunately when files get that bad they need to be re-created. It sounds like a blessing in disguise where you have improved...
  19. Replies
    8
    Views
    714

    Re: Spliting worksheet into separate files

    Hi, you haven't posted the code that inserts the page breaks but assuming you can adjust this accordingly to your needs you can try something like....


    If ActiveSheet.HPageBreaks.Count >= 1000...
  20. Replies
    12
    Views
    11,388

    Re: Calculate Net Present Value with VBA

    Of course the range could be anything you want. Have you determined how the inputs will be captured - will you ask the users to populate data into column A, a form that asks the user to identify the...
  21. Replies
    5
    Views
    470

    Re: macro skips end sub

    Hi, it appears there's more code than you posted but somewhere you have activated the sheet and hence the Worksheet_Activate code will run. Either dont select sheet, or prevent this code by running...
  22. Replies
    11
    Views
    1,191

    Re: Listbox hide, unhide problem - MVP?

    Hi, if you use the debug option and step through your code you will see your code isn't hiding the columns because this line is always false...
    If Rng.Cells(1, i) = ListBox2.Value Then

    The reason...
  23. Replies
    11
    Views
    1,191

    Re: Listbox hide, unhide problem - MVP?

    It's unclear what you mean by crazy. The fact that your clearing the list items then rebuilding is going to lead to some screen flicker, where there is a slight delay before the item you selected is...
  24. Replies
    11
    Views
    1,191

    Re: Listbox hide, unhide problem - MVP?

    Why are you clearing and rebuilding the listboxes every time someone clicks on ListBox2 - doesn't make sense.

    Also, you may find you run into trouble if KUMULATIVNA isn't the activesheet with your...
  25. Replies
    12
    Views
    11,388

    Re: Calculate Net Present Value with VBA

    You miscontrue. You havent indicated what the input will be & I dont know what you have done for the NetPVal function so not sure if it accepts a range or only an array but....

    Sub YourData()...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4