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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.