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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Do Until loop keeps looping
Thank you PHV, I didn't know you could encapsulate different commands like that. Thanks for all the help. -
Do Until loop keeps looping
Hey Skip thanks for the input...I was just testing a bunch of things out and didn't bother renaming anything. Glad you reminded me though. Thanks. I did run into a slight problem I can't seem to figure out. When doing my loop through the excel sheet I would like it to ignore case. As it is... -
Do Until loop keeps looping
Hey, figured out the issue. Thanks Skip for the help...in case someone wanted to know. If fixed the issue by using Option Explicit at the top of my script...this completely slipped my mind when creating it. Here is my modified code. Option Explicit Dim intRow, strWord, strExcel... -
Do Until loop keeps looping
Hey guys, new to the forum. I'm having troubles with a script I have. What I'm trying to do is search an excel sheet for a particular string in the first column. I want to find the row number and display the corresponding column info. Below is the test one I've been using to figure out my...
