Need help with the following code. What is the set range doing? Specifically, why is there a comma? What is 256 and the "find" doing? Pretty much if you could explain each piece of the code that would help. Thanks.
Please Login or Register to view this content.
Please Login or Register to view this content.
You can see it better the way I have laid it out. rng is being defined as starting at one cell and finishing with another. The first cell is: ActiveCell.Offset(0, 1); the second cell is: ActiveCell.Offset(0, 256 - ActiveCell.Column).
So the code is looking for whatever is in the ActiveCell anywhere in the next 255 cells on the same row. If it finds it, you get one message; if it doesn't, you get a different message.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks