Re: $$Excel-Macros$$ help regarding range selection from worksheet

2012-07-06 Thread Avinash
inash > *Sent:* Friday, July 06, 2012 10:32 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ help regarding range selection from > worksheet > > hi don thanks for your help > and sorry for i was not able to explain my requirement but can u plea

Re: $$Excel-Macros$$ help regarding range selection from worksheet

2012-07-06 Thread Avinash
Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* dguillett1 > *Sent:* Friday, July 06, 2012 9:49 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ help regarding range selection from > worksheet > > Had you

Re: $$Excel-Macros$$ help regarding range selection from worksheet

2012-07-06 Thread dguillett1
groups.com Subject: Re: $$Excel-Macros$$ help regarding range selection from worksheet Please find attached Excel sheet and run my macro for better understanding Regards, Avinash On Friday, July 6, 2012 7:22:45 PM UTC+5:30, Don Guillett wrote: If?? I understand what you want, right c

Re: $$Excel-Macros$$ help regarding range selection from worksheet

2012-07-06 Thread Avinash
t;> If Target.Column <> 1 Then Exit Sub >> Application.Goto Sheets(CStr(Target)).Range(Target.Offset(, 1)) >> End Sub >> >> Don Guillett >> Microsoft Excel Developer >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Avinash

Re: $$Excel-Macros$$ help regarding range selection from worksheet

2012-07-06 Thread dguillett1
Next i End With End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: dguillett1 Sent: Friday, July 06, 2012 9:49 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help regarding range selection from worksheet Had you explained that you want

Re: $$Excel-Macros$$ help regarding range selection from worksheet

2012-07-06 Thread dguillett1
th End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Avinash Sent: Friday, July 06, 2012 9:20 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help regarding range selection from worksheet Please find attached Excel sheet and run my

Re: $$Excel-Macros$$ help regarding range selection from worksheet

2012-07-06 Thread dguillett1
e(Target.Offset(, 1)) End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Avinash Sent: Friday, July 06, 2012 6:14 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help regarding range selection from worksheet hi ashish there is little

Re: $$Excel-Macros$$ help regarding range selection from worksheet

2012-07-06 Thread Avinash
Hi rajan it is not working i am getting this error "Subscript out of range" Regards, Avinash On Friday, July 6, 2012 6:16:27 PM UTC+5:30, Rajan_Verma wrote: > > Use this: > > > > Sub SelectRange() > > > > Dim WksSheet As Range > > Dim rngRange As Range > > Dim rngCell As Range

RE: $$Excel-Macros$$ help regarding range selection from worksheet

2012-07-06 Thread Rajan_Verma
Use this: Sub SelectRange() Dim WksSheet As Range Dim rngRange As Range Dim rngCell As Range Set rngRange = Sheet1.Range("A1").CurrentRegion For Each rngCell In rngRange.Columns(1).Cells ThisWorkbook.Worksheets(rngCell.Value).Activate

Re: $$Excel-Macros$$ help regarding range selection from worksheet

2012-07-05 Thread Avinash
Awesome Jhakaa.!!! Thank You So Much...!:) On Thursday, July 5, 2012 10:51:16 PM UTC+5:30, ashish wrote: > > try something like this > > > a2 = sheet name > b2 = cell adress > > > Sub test() > Sheets(Range("a2").Value).Range(Range("b2"

Re: $$Excel-Macros$$ help regarding range selection from worksheet

2012-07-05 Thread ashish koul
try something like this a2 = sheet name b2 = cell adress Sub test() Sheets(Range("a2").Value).Range(Range("b2").Value).Select End Sub On Thu, Jul 5, 2012 at 10:47 PM, Avinash wrote: > Hi all, > > i want help regarding range selection from worksheet. > > i have created 1 macro to select spe