; tried to get rid of application and that failed. I thought it was the
>> redundant one not worksheetfunction.
>>
>> So for cross referencing can I create a reference
>> Set pointer = sheets(chartvalue) then use pointer.cells(row,col) for
>> access since what I will be doi
bles that will be used later multiple
> times, you should initialize them to the greatest extent possible.
>
> If your purpose here is to get references to specific cells to access their
> values or properties, you should ordinarily use a Range object and create a
> reference to the range instead
c code design, but without knowing the overall intent
of your code, I can't give good advice.
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Domain Admin
Sent: Tuesday, March 27, 2012 4:54 PM
To: excel-macros@googlegroups
..@gmail.com
> -Original Message- From: Domain Admin
> Sent: Tuesday, March 27, 2012 6:54 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Difficulty referencing non active sheet but
> this must be possible
>
>
> Thanks. Believe me I am a firm believ
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Domain Admin
Sent: Tuesday, March 27, 2012 6:54 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Difficulty referencing non active sheet but
this must be possible
Thanks. Believe me I am a
m: tangledweb
> Sent: Tuesday, March 27, 2012 5:50 PM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Difficulty referencing non active sheet but this
> must be possible
>
> I have one sheet of raw data with several columns and thousands of rows. I
> need to p
but needed here.
End With
End Sub
Try to adhere to the KISS principle
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: tangledweb
Sent: Tuesday, March 27, 2012 5:50 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Difficulty referencing non active she
I have one sheet of raw data with several columns and thousands of rows.
I need to process this and I wanted to put the results on a separate sheet
with several columns and dozens of rows when done. I saw some example
code where it seemed you could do this as long as you qualified the sheet