H,
Please help regarding how to implement workdays formula.
--
Regards,
Vikram Ahuja
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote:
Need your help once again!!!
A previous project needs to be updated and I simply cannot my head around
it.
I have a workbook that currently comprises of 5 worksheets, 3 of which are
relating to my problem and are hidden.
Hi David... Once again thanks for your response, but no workbook attached,
so I cant test your code!!!
Please could you resend?
On Sunday, July 29, 2012 11:27:01 AM UTC+1, skyping1 wrote:
On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote:
Need your help once again!!!
A
Hi David... Once again thanks for your response, but no workbook attached,
so I cant test your code!!!
Please could you resend?
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Hi Sam,
Thanks for the reply,
I did the same as you have mentioned in your post i created a range A1:E9
in which i inserted data from A1:C3 and then D5:E9 and i wrote
Sheet1.range(A1:E9).Areas(1).Address but it returned $A$1:$E$9 as address
and in case of Sheet1.range(A1:E9).Areas(1).count
Hi Vikram,
The Workday() function return the next working day after the specified no
of days it excludes the weekends and the days you have specified as the
holidays.
for example if i write: =WORKDAY(DATEVALUE(11/1/2012),10) the will return
11/15/2012 because there will be weekends on 3,4 and
Prince,
I missed the part about selecting to contiguous cell groups. And come to
think of it, it doesn't necessarily have to be non-empty.
Try this
Sub T()
Dim rngCluster As Range
Dim rng As Range
Set rngCluster = Application.Union(Range(A1:C3), Range(D5:E10))
MsgBox
variable rng used as obj.. revised
Sub T()
Dim rngCluster As Range
Dim rng As Range
Set rngCluster = Application.Union(Range(A1:C3), Range(D5:E10))
For Each rng In rngCluster.Areas
MsgBox rng.Address
Next rng
End Sub
On Sun, Jul 29, 2012 at 5:05 PM, Sam Mathai
Hey, Do u have the genuine Excel 2010?? if yes, Do you mine sharing this.
Cheers,
Prabhakar
On Tue, May 29, 2012 at 10:09 PM, Ashish Pradhan ashlyprad...@gmail.comwrote:
Hey
Thanks Don and CoRe for the prompt replies. Am going ahead with the
multiple installations. Hope all goes well. :-)
Dear fellow members,
My name is Aju v chacko (41),I am
working in MRF TYRES,Kottayam,Kerala as SAP coordinator.I have moderate
knowledge in excel macros I received great help from this community.My
main hobby is reading I have created a RECONCILIATION TOOL in
Hi David,
Thank you for the file...it looks exactly what I'm after!!!
Many thanks for all your help!
Kevin
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
Hi,
I have recorded th macro for creating pivot table with pivot chart for the
1st time and running for 2nd time gives me an error - Run time error 5
Please help in changing the *vba* code as shows in Sheet(Summary) with 1
click button to go.
Request everyone to pls have this resolved asap.
hi
why do u want to use vba . simple make the dynamic range and add it to the
source of pivot whenever u will add or delete the data in source sheet it
will automatically get updated
try the attachment
visit to know more abt
http://www.contextures.com/xlPivot01.html
On Sun, Jul 29,
ya u r rite,i though abt trace dependant and add watch feature but it takes
lots of time,any short cut?
Date: Sun, 29 Jul 2012 07:45:48 +0530
Subject: Re: $$Excel-Macros$$ watch help
From: samde...@gmail.com
To: excel-macros@googlegroups.com
by effect you mean how other sheets are
What do you mean by sharing? Do you mean you want someone to support you
illegally installing a copy of office you do not have a licence for? That
is theft.
On Wednesday, 30 May 2012, Ashish Pradhan wrote:
Hey
Thanks Don and CoRe for the prompt replies. Am going ahead with the
multiple
Hi Group,
Can any one please help me to know how to align left, right and center in a
cell in excel file through shortcut key.
Thanks Regards,
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
Hi Ashish,
You won't face any version clash issue after installing Office 2010.
Installing process will offer you to keep your previous version of Office.
However the Outlook will be upgraded.
Regards,
Anoop
On Mon, Jul 30, 2012 at 1:43 AM, David Grugeon da...@grugeon.com.au wrote:
What do
17 matches
Mail list logo
