Hello Paul,
First I would like to thank you from bottom of my *heart* for making such
an *efficient code* to handle such a bad formatted data. Today I got to
know that experience pays off you're brilliant in your efforts. As I have 4
months of experience in VBA Still I understand every line of
I converted to 32 bit. Solved the whole problem :)
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thr
Check out the attached file.
I created a macro called "Cleanup".
It unmerges/unwraps cells, then deletes any column that has no entries.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all t
Dear Mandeep,
Please see the header I mean the financial year if it is FY 15-16 that
means I what to find the month in apr 15- Mar 16 in the given time period
"1 april and 30 june 19".
Im I clear or need more clarification ?
Thanks & Regards,
Ganesh N
On Fri, Nov 21, 2014 at 3:30 PM, Mandeep B
Sub Mail_Outlook_With_Signature_Html_1()
' Working in Office 2000-2013
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Dim cell As Range
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
strbody = "Hello"
For Each c
Dear Anil ,
Thanks for the intrest.Please find the attachement present in the first
post of this thred.
Lax
On Friday, November 21, 2014 9:40:10 AM UTC+5:30, अनिल नारायण गवली wrote:
> Dear Mr. Ladmanan,
>
> Pls do send an attachment.
>
> Warm Regards,
> Gawli Anil
>
> On Thu, Nov 20, 2
How can be the no of months between 1 april and 30 june 19 is 12 ? what
you are saying.
Regards,
Mandeep baluja
*Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY
20-21*
*1-Apr-15**30-Jun-19**12**12**12**12**3**0*
On Friday, November 21, 2014 3:27:20 PM UT
Dear team,
Any update on the request ?
Thanks & Regards,
Ganesh N
On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N wrote:
> I tried but I not able to find the exact month btwn the year... So I need
> the help on that...
>
> Regards,
> Ganesh N
>
> On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey wrot
Your're most Welcome.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, November 19, 2014 10:24:36 AM UTC+5:30, amar takale wrote:
>
> Dear All friends
>
> Pls solve my hyperlink issue.
>
> If
How can be the no of months between 1 april and 30 june 19 is 12 ? what
you are saying.
Regards,
Mandeep baluja
*Month* *End Month* *FY 15-16* *FY 16-17* *FY 17-18* *FY 18-19* *FY
19-20* *FY 20-21*
*1-Apr-15* *30-Jun-19* *12* *12* *12* *12* *3* *0*
On Friday, N
Dear Mandeep
Thanks very much for guidance & sorry for late reply.
Regards
Amar
On Wed, Nov 19, 2014 at 10:41 AM, Mandeep Baluja wrote:
> used name range to achieve the same :) it will not get shifted when you
> named that cell and apply link on that.
>
> Thanks
> Mandeep Baluja
>
> On Wednesd
I tried but I not able to find the exact month btwn the year... So I need
the help on that...
Regards,
Ganesh N
On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey wrote:
> USE DATEDIF FUNCTION
>
> On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N wrote:
>
>> Dear team,
>>
>> Need a help on formula to fin
USE DATEDIF FUNCTION
On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N wrote:
> Dear team,
>
> Need a help on formula to find the month btwn the years.. pls find the
> attachement.
>
> Note: its should calculate from Apr - Mar
>
> I tried but I not able to get the correct one.
>
> Thanks & Regards,
> Ga
13 matches
Mail list logo
