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
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
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
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
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
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
-Macros$$ Help regarding bank statment
hi
check the attachment see if it helps
On Fri, Jul 8, 2011 at 10:09 AM, L.K. Modi wrote:
Dear Members,
Thanks for your valuable support. I have an querry in which i have to check
interest calculation for banks.
Me attaching a sheet in
*hi LK modi
use this simpler formula
=LOOKUP(2,1/(A1:A10=A2),B1:B10)
file is attached
*Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Jul 8, 2011 at 10:56 AM, harsh shah wrote:
> HOPE THIS MIGHT BE USEFUL.
HOPE THIS MIGHT BE USEFUL.
On 8 July 2011 10:09, L.K. Modi wrote:
> Dear Members,
>
> Thanks for your valuable support. I have an querry in which i have to check
> interest calculation for banks.
>
> Me attaching a sheet in which column A have date that is in different
> format. and in column B
hi
check the attachment see if it helps
On Fri, Jul 8, 2011 at 10:09 AM, L.K. Modi wrote:
> Dear Members,
>
> Thanks for your valuable support. I have an querry in which i have to check
> interest calculation for banks.
>
> Me attaching a sheet in which column A have date that is in different
hi,
the betterr is
=DATE(YEAR(C4),MONTH(C4)+1,5)
because he wants 'next month' 5th.
R.Karunanithi
--- On Thu, 7/7/11, ashish koul wrote:
From: ashish koul
Subject: Re: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
Date: Thursday, July 7, 2011
Hi,
u use this
=DATE(YEAR(C4),MONTH(C4)+1,5)and drag the fill handle down till c4 is not
blank.
u will get what u want.
R.Karunanithi.
--- On Thu, 7/7/11, L.K. Modi wrote:
From: L.K. Modi
Subject: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
Date: Th
*ok sir
*Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jul 7, 2011 at 11:44 AM, L.K. Modi wrote:
> THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS
>
>
> REGARDS
> LKMODI
>
> On Thu, Jul 7, 2011
THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS
REGARDS
LKMODI
On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi wrote:
> Dear Members,
>
> Me attaching a sheet which relates to Excise duty payment.The result should
> be 5 of the next of the month of Invoice.We are currently doing it
*
hi L K modi use this formula in d4
=EOMONTH(C4,0)+5
*Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jul 7, 2011 at 11:29 AM, Rajan_Verma wrote:
> *Use this in D4*
>
> *=DATE(YEAR(C4),MONTH(C4)+1,5)*
>
> * *
>
Use this in D4
=DATE(YEAR(C4),MONTH(C4)+1,5)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of L.K. Modi
Sent: Thursday, July 07, 2011 10:26 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ help regarding date formula
Dear Members,
Me
use this=DATE(YEAR(C4),MONTH(C4),5)
On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi wrote:
> Dear Members,
>
> Me attaching a sheet which relates to Excise duty payment.The result should
> be 5 of the next of the month of Invoice.We are currently doing it
> manually. But is there any formula b
hi it is possible through vlookup see the attachment as i am in office in
our right now we are using MS Excel 2003 that's why i could not able to see
your file and give prompt solution but I hope this will help u if not plz
feel free to revert me.
On Tue, May 25, 2010 at 3:36 PM, Jai wrote:
>
Just paste this formula that will work same
=IF(B50="material",10.3%,4.12%)
On May 25, 3:06 pm, Jai wrote:
> Dear All
>
> 1. When we Selcet the Type of Work ( Material ) Service tax Show 4.12
> %,
>
> 2. When we Selcet the Type of Work ( Labour ) Service tax Show 10.3
> %
>
> Can
24 matches
Mail list logo
