Can anybody Explain me this below code what id does exactly?Please Login or Register to view this content.
Please Login or Register to view this content.
Can anybody Explain me this below code what id does exactly?Please Login or Register to view this content.
Please Login or Register to view this content.
The code sets To_Be_Compared to a range starting from the first row of the column the user entered and ending wherever the current Selection is.
Last edited by Norie; 08-09-2013 at 10:27 AM.
If posting code please use code tags, see here.
"To_Be_Compared" looks like a range. So, whatever letter you place in the input box for str1 will be stored. Let's say you decided to enter "J". Whichever cell you currently have selected will then be used. Let's say you have the following cell selected: "Q34". Then, "Set" makes "TBC" equal to the range "J1:Q34" Does that help?
~~LaffyAffy13~~
If I have helped you solve your problem, please be sure to click at the bottom left of my post.
Thanks.
If that takes answers your question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks