try this..
Function convertMonthName2Number(monthName As String) As Integer
' try to convert month name to actual date type
Dim dtestr As String
dtestr = monthName /1/2000
Dim dte As Date
On Error Resume Next
dte = CDate(dtestr)
If Err.Number 0 Then
convertMonthName2Number = -999
Exit
i dont understand what u mean exactly but i will jus tell u abt nested if in
excel. let me know if you wanna know nesed if for Macro.
it is if else function.
so write if and give some value if is its true and in place of else write
another if.
if you wanna know the syntax refer help in excel.
other stuff
=MONTH(DATEVALUE(1 A1 2010))
On Tue, Dec 28, 2010 at 3:34 PM, siti Vi villager.g...@gmail.com wrote:
If the word April or *another month name *is type correctly in cell A1
try this formula in B1
=TEXT(DATEVALUE(1 A1 2010),M)
On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young
If the word April or *another month name *is type correctly in cell A1
try this formula in B1
=TEXT(DATEVALUE(1 A1 2010),M)
On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young rohan.j...@gmail.com wrote:
Hi experts,
is there any formula, if i only type in cell April and the other cell
return
Hi,
A shorter version would be:
=MONTH(--(1A1))
This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended
abbreviations (eg Sept) and also unabbreviated (eg June, November)
Regards - Dave.
Date: Tue, 28 Dec 2010 15:34:01 +0700
Subject: Re: $$Excel-Macros$$ how to get month
Impressive ..!!
Good show Dave, Siti, STDEV :)
Best Regards,
DILIPandey
On Tue, Dec 28, 2010 at 4:13 PM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
A shorter version would be:
=MONTH(--(1A1))
This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended
abbreviations (eg
Hi,
Try :
Sub test2()
Dim Col As Integer, c As Range, Line As Long
Dim inCalculationMode As Integer
Application.ScreenUpdating = False
inCalculationMode = Application.Calculation
Application.Calculation = xlCalculationManual
Col = Cells(1, Columns.Count).End(xlToLeft).Column
Line =
Please, see attached file.
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Rajiv Kumar
Envoyé : lundi 20 décembre 2010 15:11
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Amount Format
Dear sir how
Hi J D,
It would be really appreciable if you can share a test file on this. Help
us to help you :)
Best Regards,
DILIPandey
On Tue, Dec 28, 2010 at 7:36 AM, J D springer...@gmail.com wrote:
I am a concrete estimator who is trying to create some cut and paste
Estimate line items I can just
I forgot to sort the columns :
Sub test2()
Dim Col As Integer, c As Range, Line As Long
Dim inCalculationMode As Integer
Application.ScreenUpdating = False
inCalculationMode = Application.Calculation
Application.Calculation = xlCalculationManual
Col = Cells(1, Columns.Count).End(xlToLeft).Column
10 matches
Mail list logo