I'm new to vba and I have a simple problem but cannot get the code to work. I have a worksheet with headers. Column D's header is "Name name". I want to search thru this column and find the text "text". When found move to the left adjacent cell (of the found "text" cell) and enter "text2". Then move on to the next cell in "Name name". Here is what I have so far. Thanks for any suggestions and help.
Please Login or Register to view this content.
Last edited by rigray; 07-14-2011 at 11:04 AM.
Hi rigray and welcome to the forum. Please take a moment and read the forum rules located here and wrap code tags around your code as per Rule #3. After you do that someone will be able to help you.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
Thanks. It should be corrected now. My apologies.
Try:
Please Login or Register to view this content.
If you need help with explanations on why stuff does what it does let me know. The .FindNext stuff can be a little confusing.
Note: This is just showing you a way using Find (no loop). You could also use a loop without Find to accomplish the same thing.
Last edited by stnkynts; 07-14-2011 at 11:13 AM.
Hi rigray, let me know if this works:Please Login or Register to view this content.
One correction, I should have not been explicit with the column number in the original post. I need the code to search for a specific column named "Name name". I am having additional problems finding a column with a space in the name. I will try to implement the other aspect as you've described. Thanks.
To find "Name name" first, use:Please Login or Register to view this content.
bah Mordred beat me to it. I used a loop on the column search just to show a different way. Here is mine:
Please Login or Register to view this content.
I was thinking more along the lines of the column search as well during my attempted implementation so I used your approach stnkynts, thanks for the help though Mordred. Anyway, I am getting and error at the definition of "lastrow". Any ideas?
I think it has something to do with mycol not getting defined properly. Here is the code now.
Please Login or Register to view this content.
ok. I found out why it was causing problems, it never found the header name I was using since I forgot i changed it on the test case. The code is running now, but it never ends and doesn't appear to be doing anything.I changed it to look at the third row for the column header name. Did I do this correctly?
Hmmm. Is your header name "EMS Composite Name" in row 3? If you could attach a copy of your workbook I could take a look at it to see where the gum up is.
I just noticed an error that i made which might be slowing things down.
Change this:
To this:Please Login or Register to view this content.
I apologize for this mistake.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks