Hi
I have tried to make some changes to a code and now it does not work! The coding is:
Code:
I have attached an example if that helps, thanks.Please Login or Register to view this content.
Hi
I have tried to make some changes to a code and now it does not work! The coding is:
Code:
I have attached an example if that helps, thanks.Please Login or Register to view this content.
Last edited by sgp; 12-12-2011 at 10:32 AM.
hi sgp, there some mistakes in the code (underlined)
Please Login or Register to view this content.
Try:
Please Login or Register to view this content.
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
Please Login or Register to view this content.
Thanks watersev, TMS and Bob Phillips! - All solutions work great!
Note that I have changed this:
r = rFind.Row - 3
To this:
r = rFind.Row - 4
As the code seemed to put the information in the wrong cells.
Regards
Wouldn't this suffice ?
To prevent non existing ID's you can fill a combobox with all valid ID's:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by snb; 12-13-2011 at 08:18 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks