Hi, I have looked through a video and the video is a little similiar to what I am going to do. But there is some issue that I am facing and would need some advice.
The problem I faced is that after printing out the data, I search again, it will have repeated search result. I am unsure of how to prevent this from happening.
And also, how do I count the number of search results?
I have attached my file for reference.
Please Login or Register to view this content.
Last edited by AlphaFrog; 08-18-2016 at 11:57 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks, it works..
Hi AlphaFrog, just to enquire one more thing, if I want to search between a range of number. Example, I want to print the data based on user input address from and address to. How should I do that?
Please Login or Register to view this content.
for the blk variable declaration, if I want to search with alphabet. E.g. 10A, I am unable to use Integer so what should I use? I have trried to string and it have error.
Or can I just search based on the user input that it contains the integer within that range?
Last edited by justin1202; 08-19-2016 at 11:35 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks