Hello everyone,
I am designing a tool to identify whether a cell has inter or intra sheet
dependents using VBA. The problem is the extremely slow speed due to
interaction with worksheet and use of 'showarrows' and 'hidearrows'
function. Can the entire sheet information be copied into VBA
Try taking all the values of the used range to a variant variable.
Example
Sub T()
Dim var As Variant
var = Worksheets(Name).UsedRange.Value
End Sub
Regards,
Sam Mathai Chacko
On Tue, Sep 4, 2012 at 9:43 PM, Ruchir Joshi ruchirjo...@gmail.com wrote:
Hello everyone,
I am designing a tool
Hi sam,
Thanks for the reply, but this would not give me information about other
cell parameters like dependents.
Ruchir
On Tuesday, September 4, 2012 9:46:15 PM UTC+5:30, Sam Mathai Chacko wrote:
Try taking all the values of the used range to a variant variable.
Example
Sub T()
Dim
No it won't. Try using
var = Worksheets(Name).UsedRange.Formula
Regards,
Sam Mathai Chacko
On Tue, Sep 4, 2012 at 9:56 PM, rjoshi88 ruchirjo...@gmail.com wrote:
Hi sam,
Thanks for the reply, but this would not give me information about other
cell parameters like dependents.
Ruchir
On
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Moving Excel worksheet information in VBA memory
No it won't. Try using
var = Worksheets(Name).UsedRange.Formula
Regards,
Sam Mathai Chacko
On Tue, Sep 4, 2012 at 9:56 PM, rjoshi88 ruchirjo