Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kwuk

  1. kwuk

    Populating multi column listbox with autofilter

    Hi, I have been using the rowsource property to populate my listboxes and have had no previous problems. But I am now having a problem as I want to use rows which have had an autofilter applied. The listbox populates, but it does so with the entire contents of the unfiltered list, rather than...
  2. kwuk

    Deleting first word in cells

    Thanks to PHV also, that could come in handy for future use.
  3. kwuk

    Deleting first word in cells

    Excellent! And so simple too. I had never seen the text to columns feature before. Have a star.
  4. kwuk

    Deleting first word in cells

    Hi, I have a excel spreadsheet in which each cell has information i want to keep, except for the first word in each cell which i want deleted. i.e. 'An example cell' - I would want the word 'An' removed. The word in each cell is different in each cell, so i cant just simply delete any...
  5. kwuk

    Type Mismatch Error

    Thanks, but im afraid this didnt work either. Although I have now realised that it always fails on the last row that contains "* church*". So basically it seems to fail at the end of the search. Still cant see why though.
  6. kwuk

    Type Mismatch Error

    Thanks guys. Have tried changing to c.text but to no effect. The row that the error occurs on seems to change each time I run it, and each time the data in the row that it fails on seems to be ok and I dont see anything obvious that would make it do so. Any other information would be great...
  7. kwuk

    Type Mismatch Error

    Hi. When running this code in excel, it works fine until it gets towards the end of the sheet, then gives a run error 13, type mismatch. After that, every time i try to run the code, it fails straight away. Here is the code in question. I know it looks a bit shoddy, but i'm kind of learning as...
  8. kwuk

    Locating row to add data

    Thanks SkipVought, this worked perfectly. Thanks to xlbo too.
  9. kwuk

    Locating row to add data

    Thanks for the response, but it seems that this only directs me to the next row along from where I currently am. I'll try to explain a little better about what i need. My worksheet is already populated with a column of employee numbers. What I want is for excel to find the row that has the...
  10. kwuk

    Locating row to add data

    Hi all, This is probably an easy request, but it seems my mind has turned to mush, so any help would be appreciated. I have a user form on my spreadsheet and am using text boxes to collect data. One of the boxes collects an employee number, the other an address. I want the address to be sent...
  11. kwuk

    Cancelling command prompt from VB

    Unfortuately, its the user I'm messaging, as they move around from machine to machine all the time. Thanks anyway.
  12. kwuk

    Cancelling command prompt from VB

    Hi, I am working with VB6 on a program that uses NET SEND from the command line to send messages to a list of users. The problem I am having is that occasionally, some of the users on my list are not connected, and so the command prompt window stays open for minutes at a time trying to locate...
  13. kwuk

    'Net send' command query

    Works perfectly. Thanks
  14. kwuk

    'Net send' command query

    I am able to use the net send command to broadcast messages to individual workstations or across the whole domain, however I have been unable to find a method of sending to specific user groups. Is this possible? I know there are a number of GUI utilities that allow you to do this, but ideally...
See more

Part and Inventory Search

Back
Top