LinkBack URL
About LinkBacks
Hi ,,,
I have a data validation list in B2 .. I want to update its source when I enter the page
I want the source to be the following : "=template!$B$3:$B$last row"
which is from B3 to last row in B in "template" sheet
how can I do that using VBA ??
Hi ,,,
I have a data validation list in B2 .. I want to update its source when I enter the page
I want the source to be the following : "=template!$B$3:$B$last row"
which is from B3 to last row in B in "template" sheet
how can I do that using VBA ??
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
Thanks TMShucks .. but my problem not this ..
what to write before this part of code "=template!$B$3:$B$" & lastrow ????
this was my try .. but for sure it is wrong !!
I want to know how to make it pleeeease ..Please Login or Register to view this content.
Please Login or Register to view this content.
Regards, TMS
Thanks TMS .. thats what I want
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks