LinkBack URL
About LinkBacks
Use the absolute row reference for Teams!1:1.
Otherwise, the row changes relative to your dropdown list row.
Formula:
=OFFSET(Teams!$A$1,0,0,1,COUNTA(Teams!$1:$1)-1)
Use the absolute row reference for Teams!1:1.
Otherwise, the row changes relative to your dropdown list row.
Formula:=OFFSET(Teams!$A$1,0,0,1,COUNTA(Teams!$1:$1)-1)
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks