Re : Excel HyperLink by OffSet Leaping to Active Selection

  • Thread starter Thread starter TKT-Tang
  • Start date Start date
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.
 
Back
Top