T
TKT-Tang
Re : Excel HyperLink by OffSet Leaping to Active Selection
1. Enter an Excel worksheet and a relatively small tabulation named
TabLet thereof.
2. TabLet takes the range of say, B2:C18.
3. Tablet is filled in the top rows, leaving several blank ones
towards the base of the tabulation.
4. Enter the following formula into Cell B1 :-
=HYPERLINK("#"&ADDRESS(MAX(
IF(ISBLANK(
OFFSET(TabLet,0,Column()-Min(Column(TabLet)),
ROWS(TabLet),1)),
FALSE,ROW(TabLet)))+1,COLUMN()),"Resume")
5. The resultant HyperLink is given to Resume active selection at one
row below the filled range of Column-B.
6. However, test results have shown otherwise. But, Why?!
7. Please comment and share your experience. This is XL-2000.
8. Regards.
1. Enter an Excel worksheet and a relatively small tabulation named
TabLet thereof.
2. TabLet takes the range of say, B2:C18.
3. Tablet is filled in the top rows, leaving several blank ones
towards the base of the tabulation.
4. Enter the following formula into Cell B1 :-
=HYPERLINK("#"&ADDRESS(MAX(
IF(ISBLANK(
OFFSET(TabLet,0,Column()-Min(Column(TabLet)),
ROWS(TabLet),1)),
FALSE,ROW(TabLet)))+1,COLUMN()),"Resume")
5. The resultant HyperLink is given to Resume active selection at one
row below the filled range of Column-B.
6. However, test results have shown otherwise. But, Why?!
7. Please comment and share your experience. This is XL-2000.
8. Regards.