Hi Natron,
I can't see any attachment here.
Well, I hope you can simply get a range in a variable as follows:
dim myRange as range
set myRange= Worksheets(index).Range(define_range)
and then you can call this range anywhere.
Regards,
Anoop
On Wed, Nov 21, 2012 at 6:42 PM, Natron wrote:
> My
My apologies Anoop, I hope you can understand my code, I tried to comment
it at key locations. I attached a workbook the second go around.
On Tuesday, November 20, 2012 9:38:32 PM UTC-5, Enrique Martin wrote:
> It's better to attach the file and put you query there.
> No one gonna study this co
It's better to attach the file and put you query there.
No one gonna study this code as different people have different logic.
Regards,
Anoop
On Tue, Nov 20, 2012 at 1:49 AM, Natron wrote:
> This is close and might get you a kickstart.
>
> Sub selectme()
> ''
> 'Origina
This is close and might get you a kickstart.
Sub selectme()
''
'Original Script Written by www.ozgrid.com
''
Dim rRange As Range
Dim strCriteria As String, strCriteria2 As String
Dim lCol As Long
Dim rHeaderCol As Range
Dim xlCalc As XlCalculation