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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dawa1234

    Run Time Error '1004' and Range Class

    aMember, I found that as long as I didn't put the call to the sort routine in the activate procedure of a worksheet, it seemed to work fine. I think I have found a valid work around though. I do have command buttons; however, why do you say to change the TakeFocusOn click Property to false...
  2. dawa1234

    Run Time Error '1004' and Range Class

    I keep getting this error that says "Run Time Error '1004' Select Method of Range Class Failed" and if I debug it, it points to ".Range(sortRange).Select" Public Sub Sorts() With Worksheets(sheetName) .Range(sortRange).Select Selection.Sort Key1:=Range(Key)...
  3. dawa1234

    Testing for a Border Property in Excel

    Well that seemed to do the trick. Thanks again. [smile]
  4. dawa1234

    Testing for a Border Property in Excel

    Here's what I need to do. I need to be able to test for a border property in excel using VBA. I have the top, bottom and two borders on each cell and some cells had the diagonal up and the diagonal down borders. I need to test for the diagonal borders. Any ideas? i've tried If...
  5. dawa1234

    VBA Excel97 Worksheet Copy

    Hi hsummer, I have had the exact same problem with Excel97 and Excel2000. But you are in luck. The problem is when you run the VBA app in Excel2000, the object libraries change. To fix it, put excel into design mode, then open up the VB Editor Go to Tools, and then References. Under here...
  6. dawa1234

    Accessing Checkboxes added to Listbox at Runtime

    Ok, here's what I have. I have been working on VBA with Excel, and I have a bunch of listboxes with a bunch of checkboxes that get added to the listboxes at run time. I need to be able to possibly get to the Enabled property of the checkboxes, but if i try using "List1.list(i).Enabled =...

Part and Inventory Search

Back
Top