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 TouchToneTommy 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: *
- Users: 000Steve000
- Content: Threads
- Order by date
-
Detecting Color change in Excel cell
I would like to run a macro to check the contents of a cell when a user chages its colour. The colour change does not trigger the worksheet change event. Can anyone help?- 000Steve000
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Help me speed up my macro as it writes to a worksheet
I currently have a large amount of data (10000 rows x 10 columns) of string data held in an array during the execution of a macro. I would like to write this to an empty sheet. I am currently using a for and next loop like: For 1 = 1 to 10000 worksheets(1).cells(i,1) = Myarray(i,1)...- 000Steve000
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Another WshShell.Run Problem
Why does - Return = WshShell.Run("notepad", 1, true) return a '0' and wait for notepad to close before executing the next line of script, but - Return = WshShell.Run("explorer", 1, true) return a 1 and continues the rest of the script without waiting for explorer to end? Explorer is not the...- 000Steve000
- Thread
- Replies: 10
- Forum: VBScript
