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 ??