-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 wrote:
> Hi sam,
>
> Thanks for the r
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 wrote:
> Hi sam,
>
> Thanks for the reply, but this would not give me information about other
> cell parameters like dependents.
>
> Ruchir
>
>
> On Tuesday, Se
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()
>
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 wrote:
> Hello everyone,
>
> I am designing a tool to identify whet
