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
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
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
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
..@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
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
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
; 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