Hey
Is it possible to simplify this code:
I want to make an efficient (fast) code, but this looks terrible. ....any suggestions?Please Login or Register to view this content.
Hey
Is it possible to simplify this code:
I want to make an efficient (fast) code, but this looks terrible. ....any suggestions?Please Login or Register to view this content.
I'm mediocre with VBA, but getting there
Hi KBSH,
Instead of
tryPlease Login or Register to view this content.
See if that makes more sense and works better for you.Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I don't know the code InStr(), but found out that it worked, so thanks. I did actually hope that it would be more something like Activecell.value = OTA
The thing that I actually ment is that I have to declare twice that I'm looking for characters like "A" "T" and "O"
Can't this be done with just one line?Please Login or Register to view this content.
Last edited by KBSH; 03-05-2016 at 03:12 PM.
I tried using Instr but for some reason I was getting errors so I decided to use match.
Please Login or Register to view this content.
Last edited by mehmetcik; 03-05-2016 at 03:21 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks mehmetcik. I didn't know that you can work with numbers in front of your code and refer to those numbers. Very useful
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks