-- Forwarded message --
From: Ashish Bhalara
Date: Wed, Apr 2, 2014 at 4:10 PM
Subject: Fwd: $$Excel-Macros$$ Show links which to other Data source
To: "excel-macros@googlegroups com"
-- Forwarded message --
From: Ashish Bhalara
Date: Tue, Apr 1, 20
End If
Next
Next
End If
Err.Clear
Set rng = Nothing
Next
End Sub
On Wed, Apr 2, 2014 at 4:10 PM, Ashish Bhalara wrote:
>
>
> -- Forwarded message --
> From: Ashish Bhalara
> Date: Tue, Apr 1, 2014 at 1:
-- Forwarded message --
From: Ashish Bhalara
Date: Tue, Apr 1, 2014 at 1:23 PM
Subject: $$Excel-Macros$$ Show links which to other Data source
To: "excel-macros@googlegroups com"
Dear experts,
My workbook containing large no. of sheets & formulas, but I want
Sub find_links()
Dim extlinks
Dim j As Long, k As Long
Dim wkb As Workbook
Dim rng As Range, cl As Range
Dim links1 As String
Dim links2 As String
Set wkb = Workbooks.Add
wkb.Sheets(1).Range("a1").Value = "Cell Address"
wkb.Sheets(1).Range("b1").Value = "Formula"
Dear experts,
My workbook containing large no. of sheets & formulas, but I want to show
those formulas which containing links to other data source of file. Kindly
know me how to check it.
--
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Sp