Dear Anoop,
Thanks great,Exactly I want.I try this many time but not successful how to
extract arrow (Neutral) where it is in excel in symbol I got but it is half
arrow then I use it two half arrow with merge with concatenate which is use
in attached sheet.But now you send me perfect arrow if it
Hi Pravin,
Whenever you move from one cell to other Worksheet_SelectionChange event
is called thats why it is not allowing you to update the sheet.
Regards
Prince
On Thursday, December 13, 2012 1:24:00 PM UTC+5:30, Pravin Gunjal wrote:
*Dear Friends,*
* *
*I am using the following
Hi Prince
Then please let me know , how can I do the changes.
Regards
Pravin.
-- Forwarded message --
From: Prince prince141...@gmail.com
Date: Thu, Dec 13, 2012 at 2:09 PM
Subject: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with manual
protect / unprotect
To:
Thanks alot Prince. Much appreciated.
Regards,
Boreh
On 13 December 2012 11:59, Prince prince141...@gmail.com wrote:
Hi Kip,
Just copy this function and paste it in your workbook. The bold one last
line i have updated into this.
Function PRICE364(settlement As Date, maturity As Date,
*This link may help you :* http://www.contextures.com/excelfiles.html#Pivot
*Regards*
*Pravin.*
-- Forwarded message --
From: SHAIL GROUPS shail.gro...@gmail.com
Date: Thu, Dec 13, 2012 at 12:10 PM
Subject: $$Excel-Macros$$ i want use pivot table in multi sheet of excel
2007
To:
Hi Pravin,
You should palce this code on Worksheet_Activate() event and befor
udating the sheet protact it.For updating the sheet unprotact it from menu
bar.
regards
Prince
On Thursday, December 13, 2012 2:29:57 PM UTC+5:30, Pravin Gunjal wrote:
Hi Prince
Then please let me know , how
Dear Prince,
By doing the changes suggested by you, the macro is not working properly.
Pl confirm.
Regards
Pravin.
-- Forwarded message --
From: Prince prince141...@gmail.com
Date: Thu, Dec 13, 2012 at 2:44 PM
Subject: Re: $$Excel-Macros$$ Re: Macro enabled sheet to be worked
Hi Pravin,
Share your workbook.
Regards
Prince
On Thursday, December 13, 2012 3:13:50 PM UTC+5:30, Pravin Gunjal wrote:
Dear Prince,
By doing the changes suggested by you, the macro is not working properly.
Pl confirm.
Regards
Pravin.
-- Forwarded message --
From:
Hi Steve,
Not able to understand what exactly you want. Can you explain it with any
example or provide what answer you want in saperate column and highlight
fields you use to get that answer. So it will be easy to find way to do it.
Regards,
Swapnil.
On Thu, Dec 13, 2012 at 1:20 AM, Steve
Hi Guys
i managed to solve this thanks
On Wed, Dec 12, 2012 at 1:27 PM, Hilary Lomotey resp...@gmail.com wrote:
[image: Boxbe] https://www.boxbe.com/overview This message is eligible
for Automatic Cleanup! (resp...@gmail.com) Add cleanup
Dear all,
I need to know how convert below code , so that any file path get replaced
by below code
ActiveWorkbook.ChangeLink Name:= c:\USER\app\Management Level Adj..xlsm _
, NewName:=Management Level Adj..xlsm, Type:=xlExcelLinks
Regards,
Prashant
--
Join official Facebook page
Need Data Range upto 99000 in this sheet data Range upto only 2000
me try to change Data Range but its dosent work
Pls do need full
Thanks
Dhaval Shah
98240 35253
On Wed, Dec 12, 2012 at 10:43 PM, Prince prince141...@gmail.com wrote:
Hi Dhaval ,
Pls find Attached.
Regards
Prince
On
That is correct.
# (days) / 7 (days/week) = # (weeks)
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 the times you can,
To all the people you can,
As long as ever you can.” - John
Hello
In the attached file, i need assistance to be able to enter dates in the
format dd-mmm-yy, and also to alert the user to enter dates in that format,
i want the textbox1 to always pick the current date but date should be
editable. thanks
--
Join official Facebook page of this forum @
Hilary,
Your file is in .xlsx format.
As such, it does not contain your userform or macros.
Please attach a .xlsb (or .xlsm) file so that we can assist you.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the
sorry my bad
PFA
On Thu, Dec 13, 2012 at 2:27 PM, Paul Schreiner schreiner_p...@att.netwrote:
[image: Boxbe] https://www.boxbe.com/overview This message is eligible
for Automatic Cleanup! (schreiner_p...@att.net) Add cleanup
try this code
Sub dateformat()
UserForm1.Show
UserForm1.TextBox1.Value = VBA.Format(VBA.Date, DD-MMM-)
End Sub
On Thu, Dec 13, 2012 at 8:17 PM, Hilary Lomotey resp...@gmail.com wrote:
sorry my bad
PFA
On Thu, Dec 13, 2012 at 2:27 PM, Paul Schreiner schreiner_p...@att.netwrote:
Hi experts,
I want to calculate no of workdays and excludes holiday
For examples 24/12/2012 to 28/12/2012 and exclude 25th 26 th as holiday
I tried using =Networkdays but I was able to no of working days
Please help me to Exclude holiday.
Thanks
Manjunath
Hi experts,
I want to calculate no of workdays and excludes holiday
For examples 24/12/2012 to 28/12/2012 and exclude 25th 26 th as holiday
I tried using =Networkdays but I was able to no of working days
Please help me to Exclude holiday.
Thanks
Manjunath
Hello
When i click on a command button on my userform, it takes close to 50 secs
before the information is processed to the worksheet. what could be
accounting for this. is there a way to minimize the time?. thanks
--
Join official Facebook page of this forum @
hi
you can write some code on command button click
with application
.screenupdating=false
.calculation= xlcaluationmanual
end with
-Prsent code--
with application
.screenupdating=true
.calculation= xlcaluationautomatic
end with
On Thu, Dec 13, 2012 at 9:16 PM, Hilary
thanks chief , but which of the codes shd i use, you provided two
On Thu, Dec 13, 2012 at 3:58 PM, Divaker Pandey divake...@gmail.com wrote:
[image: Boxbe] https://www.boxbe.com/overview This message is eligible
for Automatic Cleanup! (divake...@gmail.com) Add cleanup
Chief, its work beautifully, you are great thanks
On Thu, Dec 13, 2012 at 4:14 PM, Hilary Lomotey resp...@gmail.com wrote:
thanks chief , but which of the codes shd i use, you provided two
On Thu, Dec 13, 2012 at 3:58 PM, Divaker Pandey divake...@gmail.comwrote:
[image: Boxbe]
use both code
and keep your current code between them
On Thu, Dec 13, 2012 at 9:44 PM, Hilary Lomotey resp...@gmail.com wrote:
thanks chief , but which of the codes shd i use, you provided two
On Thu, Dec 13, 2012 at 3:58 PM, Divaker Pandey divake...@gmail.comwrote:
[image: Boxbe]
Thanks!
Keep in mind that:
Excel doesn't have dates.
What it DOES is allows us to DISPLAY a number (the number of days since
1/1/1900)
in multiple ways. SOME of which represents a date!
That being said, your userform doesn't have a Date.
It has a Text box.
the contents of this text box is a
use this one
=NETWORKDAYS(DATEVALUE(12/24/2012), DATEVALUE(12/28/2012),A:A )
Let Range A:A contains list of holidays
On Thu, Dec 13, 2012 at 8:47 PM, Manjunath Narayanappa
manjunath.narayana...@aon.co.uk wrote:
Hi experts,
I want to calculate no of workdays and excludes holiday
For
Dear excel guru is there any way to make data validation effective in case the
source data is copied from other source! (As I have observed that data
validation would not work in case some data is copied from other source!!!
Please help!
Sandeep Chhajer.
Sent on my BlackBerry® from
how did you (or did you) specify the holidays in the NetWorkdays function?
Microsoft has no way of knowing what days YOU consider holidays.
Every country has their own national holidays.
Employers may choose which of these holidays to observe.
So, Networkdays and NetWorkDays.intl have the
Thanks
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Prince prince141...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Dec 2012 08:38:12
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Cc: Prince Kumarprince141...@gmail.com
Hi Manjunath,
solved your query, please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Thu, Dec 13, 2012 at 8:45 PM, Manjunath Narayanappa
manjunath.narayana...@aon.co.uk wrote:
Hi experts,
I want to calculate no of workdays and excludes holiday
SPOT ON PAUL. 120% ACCURATE .. VERY GRATEFUL
On Thu, Dec 13, 2012 at 4:31 PM, Paul Schreiner schreiner_p...@att.netwrote:
UserForm1.TextBox1.Value = Format(Now(), dd-mmm-)
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise,
Results of the recent Calendar Challenge are IN !
The competition was furious, and the judging, difficult.
The goal was to create a calendar in excel using Functions ONLY (no user
defined macros).
The calendar should be displayed on a single sheet, and update dynamically
for any given year.
Just what the doctor ordered. Thank you very much Dr. Anoop.
Much appreciated.
On Thursday, December 13, 2012 1:59:22 AM UTC-5, Enrique Martin wrote:
Hi Bill,
I have modified the code which will work within stipulated time as
described above.
I have also provided two command buttons
Can we see all the calenders of participants?
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Paul Schreiner schreiner_p...@att.net
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Dec 2012 11:11:20
To: excel-macros@googlegroups.com
Reply-To:
Congratulations to the winners
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Paul Schreiner schreiner_p...@att.net
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Dec 2012 11:11:20
To: excel-macros@googlegroups.com
Reply-To:
My Pleasure.. You have given me new title.
On Fri, Dec 14, 2012 at 12:57 AM, Bill Q ronsmith...@gmail.com wrote:
Just what the doctor ordered. Thank you very much Dr. Anoop.
Much appreciated.
On Thursday, December 13, 2012 1:59:22 AM UTC-5, Enrique Martin wrote:
Hi Bill,
I
Congrats Winners :)
Regards
Prince
On Friday, December 14, 2012 1:19:42 AM UTC+5:30, hilary lomotey wrote:
Congratulations to the winners
Sent from my BlackBerry® smartphone from Airtel Ghana
--
*From: * Paul Schreiner schrein...@att.net javascript:
*Sender: *
Hi Sandeep,
Can you please share ur workbook so that i can understand your problem.
Regards
Prince
On Thursday, December 13, 2012 10:13:29 PM UTC+5:30, sandeep chhajer wrote:
Dear excel guru is there any way to make data validation effective in case
the source data is copied from other
Hi,
It would be a lot better if we could see the calenders submitted. If
required I can provide web space to host these files too.
Warm regards,
Anand Kumar
On Sunday, 18 November 2012 21:53:29 UTC+5:30, Ayush Jain wrote:
Dear members,
Let's get set for the new year 2013
Here is inviting
*Dear Sir,*
*
*
*It would be better, if you send those calenders to see.*
*Thank you,*
*
*
*Regards*
*Pravin Gunjal*
-- Forwarded message --
From: Paul Schreiner schreiner_p...@att.net
Date: Fri, Dec 14, 2012 at 12:41 AM
Subject: $$Excel-Macros$$ Re: Dynamic calendar quiz : There
Dear Pravin,
Solution is Perfect as like me.How to do it, any logic for code (true
false) I will also try for 4th chart.And one more Chart is movable from
here to there Can I fixed this one place.
Thanks again
Amar
On Fri, Dec 14, 2012 at 10:38 AM, Pravin Gunjal isk1...@gmail.com wrote:
*Hi
Hi Amar,
PFA the chart sheet, might it will help you out.
-deba
Thanks Regards,
*Deba ranjan*
On Fri, Dec 14, 2012 at 11:05 AM, amar takale amartak...@gmail.com wrote:
Dear All Experts,
Can you help me above two file,last week you help me which is very
Helpful
Attachment missed...
Hi Amar,
PFA the chart sheet, might it will help you out.
-deba
Thanks Regards,
*Deba ranjan*
On Fri, Dec 14, 2012 at 11:23 AM, Deba Ranjan drdeva...@gmail.com wrote:
Hi Amar,
PFA the chart sheet, might it will help you out.
-deba
Thanks
Dear Deba Rajan,
First Congratulation for winner of Calendar quiz.Dear Deba which you send
file it is fantastic,Mind blowing,I like it very much.It is also
very useful our Excel user Group members.
Regards
Amar
On Fri, Dec 14, 2012 at 11:24 AM, Deba Ranjan drdeva...@gmail.com wrote:
Thanks Amar !!
Thanks Regards,
*Deba ranjan*
On Fri, Dec 14, 2012 at 11:52 AM, amar takale amartak...@gmail.com wrote:
Dear Deba Rajan,
First Congratulation for winner of Calendar quiz.Dear Deba which you send
file it is fantastic,Mind blowing,I like it very much.It is
Dear Deba
Again Thanks for help,if i want more than 3 chart show how to modify code.
On Fri, Dec 14, 2012 at 11:44 AM, Deba Ranjan drdeva...@gmail.com wrote:
Amar,
U can see this attachment also. PFA. might it will help you.
Thanks Regards,
*Deba ranjan*
On Fri, Dec
i have send you two attachment, which you are taking about ?
Thanks Regards,
*Deba ranjan*
On Fri, Dec 14, 2012 at 11:56 AM, amar takale amartak...@gmail.com wrote:
Dear Deba
Again Thanks for help,if i want more than 3 chart show how to modify code.
On Fri, Dec 14, 2012 at 11:44
Respected Guru's,
I have a curious question i.e why cannot pie chart represent two sets of
values.For Example if I Take a table with Employee Name ,Salaries ,PF. I
can get Pie Chart for only for only two sets of values only like Name
Salaries,Name PF etc.Why do not we get a pie chart for more
I talk about second attachment (VBA Chart show hide.xls)
On Fri, Dec 14, 2012 at 12:01 PM, Deba Ranjan drdeva...@gmail.com wrote:
i have send you two attachment, which you are taking about ?
Thanks Regards,
*Deba ranjan*
On Fri, Dec 14, 2012 at 11:56 AM, amar takale
Hi Deba Rajan,
Thank very much for more time spend on my solution.
Very Helpful and thanks again providing this helpful knowledge
Regards
Amar
On Fri, Dec 14, 2012 at 12:16 PM, Deba Ranjan drdeva...@gmail.com wrote:
Ok, i have not used any coding there just simple formula as well the combo
50 matches
Mail list logo
