Hello,
2.
If ActiveCell.HasFormula Then
msgbox "The active cell contains a formula"
End If
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de hanumant shinde
Envoyé : samedi 18 décembre 2010 22:00
À : Excel Group
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
L
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 wrote:
> I am a concrete estimator who is trying to create some cut and paste
> Estimate line items I can just grab from one spread
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 ca
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 = Cells(Cells.Row
Impressive ..!!
Good show Dave, Siti, STDEV :)
Best Regards,
DILIPandey
On Tue, Dec 28, 2010 at 4:13 PM, Dave Bonallack
wrote:
> Hi,
> A shorter version would be:
> =MONTH(--(1&A1))
> This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended
> abbreviations (eg Sept) and also unab
Hi,
A shorter version would be:
=MONTH(--(1&A1))
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 Occ
other stuff
=MONTH(DATEVALUE("1 "&A1&" 2010"))
On Tue, Dec 28, 2010 at 3:34 PM, siti Vi 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 wrote:
> Hi experts,
>
> is there any formula, if i only type in cell April and the other cell
> return the value
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
Exi
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. ju
11 matches
Mail list logo
