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
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
: $$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 please explain
me how this code is working and what if the range table which is mentioned in A
and B column is in M and N column???
what will
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
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
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
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
Range(rngCell.Offset(, 1).Value).Select
>
> Next rngCell
>
>
>
>
>
> End Sub
>
>
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
>
groups.com
Subject: $$Excel-Macros$$ help regarding range selection from worksheet
Hi all,
i want help regarding range selection from worksheet.
i have created 1 macro to select specific range from sheet and for that
matter i have used below mentioned code
Sheets("sheet1").Selec
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"
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
Hi all,
i want help regarding range selection from worksheet.
i have created 1 macro to select specific range from sheet and for that
matter i have used below mentioned code
Sheets("sheet1").Select
ActiveSheet.Range("C7:BS37").Select
my macro should work on range which i have mentioned in the
12 matches
Mail list logo
