Re: $$Excel-Macros$$ Re: Please help - How to export specific range by ID to other excel file.

2012-11-26 Thread Anoop K Sharma
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

Re: $$Excel-Macros$$ Re: Please help - How to export specific range by ID to other excel file.

2012-11-21 Thread Natron
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

Re: $$Excel-Macros$$ Re: Please help - How to export specific range by ID to other excel file.

2012-11-20 Thread Anoop K Sharma
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

$$Excel-Macros$$ Re: Please help - How to export specific range by ID to other excel file.

2012-11-19 Thread Natron
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