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!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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)...- dawa1234
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- dawa1234
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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 =...- dawa1234
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
