please check this vba code, hope it helps..
-Standard Module
Sub ExpiryWarning()
' siti Vi // Jakarta, 19 Jan 2011
'
Dim dTable As Range, t As String
Dim R As Long, N As Long, I As Integer
Set dTable = Cells(1).CurrentRegion
N = dTable.Rows.Count
I need a 0 in A1, data starting in A2:B2. Starting date in D1 (calendar one
eg. 12/1/2008), end date in D2.
Formula for a is (array formula, validate with Ctrl+Shift+Enter) :
=SUMPRODUCT((A2:A1001=D1)*(A2:A1001=D2)*IF(DAY(A2:A1001)DAY(A1:A1000),1,0
Hi All,
I am having 1 Excel sheet which contains 3 sheets
In sheet1 main database i have to update in every month for Leave
calculation
In Sheet2 I have to find out the total leaves taken in that month with dates
of IL NCNS Staus from Sheet 1 (details given in attached sheet)
In sheet3 i have
Hi Friends,
I really need urgent help. i want to deliver smthing by tomorrow and i stuck
here.
Selection.FormulaArray =
=RC[-4]:R[46]C[-4]RC[-3]:R[46]C[-3]RC[-2]:R[46]C[-2]
I have this formula and instead of 46th row i want to use Variable Z. i tried
below things but its not working
'
Hello,
This one works for me :
Selection.FormulaArray = _
=RC[-4]:R[ Z ]C[-4]RC[-3]:R[ Z ]C[-3]RC[-2]:R[ Z
]C[-2]
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de hanumant shinde
Envoyé : dimanche 19 juin 2011
Hello,
Try :
Sub test1()
Dim Enrgt As String
Close #1
Close #2
mypath = d:\donnees\daniel\mpfe\ 'files path, please change
Open mypath RPTbamCommon Maintenance201106061432493.txt For Input As #1
Open mypath Output.txt For Output As #2
Do While Not EOF(1)
Line Input #1, Enrgt
Dear Experts
I need your help how to print at a time more than 5 files excel and word
gather. I will be very obliged if anybody can support me as earlier as
possible.
Best Regards
Azeem Quraishi
--
Selection.FormulaArray = =RC[-4]:R[ z ]C[-4]RC[-3]:R[ z
]C[-3]RC[-2]:R[ z ]C[-2]
On Jun 19, 4:29 pm, hanumant shinde arsfan2...@yahoo.co.in wrote:
Hi Friends,
I really need urgent help. i want to deliver smthing by tomorrow and i stuck
here.
Selection.FormulaArray =
Hi everybody,
I´m newbie in the group and I´m trying to create my first calendar.
I´m following step by step this video in youtube:
http://www.youtube.com/watch?v=YA7-d3sadc0
but just in the beginning of the process my formula isn´t working
=Date(B1,B2,1)
and I´m just copying exactly as I´m
Hi Saravanan
check whether this help
http://www.rondebruin.nl/key.htm
Thanks
Mahesh
On Fri, Jun 17, 2011 at 8:35 PM, saravanan R sarva0...@gmail.com wrote:
Hi Excelates,
I need an Urgent help on disabling the Sort in the filter dropdown.
Is there a way to disable only the short cut key
Hey thanks it worked. Perfect solution
Mahreen
On Sun, Jun 19, 2011 at 11:59 AM, STDEV(i) setiyowati.d...@gmail.comwrote:
please check this vba code, hope it helps..
-Standard Module
Sub ExpiryWarning()
' siti Vi // Jakarta, 19 Jan 2011
'
Dim
Hello,
Is the comma your decimal symbol ?
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de F4b10cut3r
Envoyé : dimanche 19 juin 2011 16:43
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ My first calendar
12 matches
Mail list logo