Re: $$Excel-Macros$$ Re: Custom Formatting in Excel

No, I just wan to retain value upto 10 decimal in excel cell but to display lowest whole no irrespective of value after decimal points > or <=.5 On Sun, Jun 18, 2017 at 9:41 AM, GENIUS wrote: > look at the sheet, may be you required this. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

$$Excel-Macros$$ Custom Formatting in Excel

Hi Champs, I am sharing excel File; where a value 41726.8901269684 is stored in cell. I want to display only 41726 using Custom Formatting while retaining same value in that cell irrespective of decimal part > or < .5 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Create a Pivot based on Another Pivot

Hi Experts, Can we create a pivot based on another pivot?(*Interview Question*) Regards, Soumyendu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

$$Excel-Macros$$ Connect Third party Application using VBA

Hi I am log into a website using user id & pwd from excel. After login a new window pops up with software conatining user form with no browser. I need to click on a button of that user form. I have already tracked down .exe file name from task bar. How to connect with that form using vba? Is there

Re: $$Excel-Macros$$ Sort Date on the Basis of Day

Hi, Is there anyone to help? On Mon, Aug 31, 2015 at 5:18 AM, Soumyendu Paul wrote: > Hi, > In attached file there is a date column containing all dates of > September month. I want to sort data like 1Sep, 2Sep, 3rd Sep irrespective > of year using VBA. Please help me. > Regar

$$Excel-Macros$$ Sort Date on the Basis of Day

Hi, In attached file there is a date column containing all dates of September month. I want to sort data like 1Sep, 2Sep, 3rd Sep irrespective of year using VBA. Please help me. Regards, Soumyendu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW)

$$Excel-Macros$$ Urgent Help Required

Hi, Want to search header "Name" in attached file through vba but unable to do with find method. Please help Regards, Soumyendu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.co

Re: $$Excel-Macros$$ Remove Outlook Security Alert(Urgent!)

Is there anyone to help? On Tue, Aug 4, 2015 at 2:28 PM, Soumyendu Paul wrote: > In my case Antivirus is installed; so this option is disabled > > On Tue, Aug 4, 2015 at 2:25 PM, Abhishek Jain > wrote: > >> What worked for me on Outlook 2007 - >> >> Run Outloo

Re: $$Excel-Macros$$ Remove Outlook Security Alert(Urgent!)

tic Access, select - Never warn me about suspicious > activity > > HTH, Abhishek > > On Tue, Aug 4, 2015 at 2:12 PM, Soumyendu Paul > wrote: > >> Hi, >> >> How to remove Outlook Security Alerts without using Application.wait & >> Sendkeys >>

$$Excel-Macros$$ Remove Outlook Security Alert(Urgent!)

Hi, How to remove Outlook Security Alerts without using Application.wait & Sendkeys Regards, Soumyendu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RU

Re: $$Excel-Macros$$ Filter Data for Current Month

Is there anyone to help? On Tue, Aug 4, 2015 at 10:43 AM, Soumyendu Paul wrote: > I want to filter all data for all July irrespective of year > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook pag

$$Excel-Macros$$ Filter Data for Current Month

I want to filter all data for all July irrespective of year -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles.

$$Excel-Macros$$ Query in VBA

Dear All, My query for attached file When we select data from drop down A cursor to move A6;when we select B from drop down cursor move down B13 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https

$$Excel-Macros$$ Query

In attachment; sheet1 we are sending a mail on clicking a shape. My query is to give an alert(like popup message box) when shape is not cliked -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://w

Re: Fwd: $$Excel-Macros$$ Query (Outlook VBA)

Thanks for help On Jun 3, 2015 4:43 PM, "Soumyendu Paul" wrote: > -- Forwarded message ------ > From: "Soumyendu Paul" > Date: Jun 3, 2015 4:21 PM > Subject: $$Excel-Macros$$ Query (Outlook VBA) > To: > Cc: > > Hi, > > I have an ou

$$Excel-Macros$$ Query (Outlook VBA)

Hi, I have an outlook message stored in hard drive folder. Want to read this file for extracting data into excel. Please help!! Regrds, Soumyendu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ http

$$Excel-Macros$$ Urgent Help Required!(VBA Outlook)

Hi, -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help

Re: $$Excel-Macros$$ Outlook Signature Problem using VBA

Thanks Ashish Regards, Soumyendu On Thu, May 28, 2015 at 10:37 AM, ashish koul wrote: > try example 1 > > http://www.rondebruin.nl/win/s1/outlook/signature.htm > > On Thu, May 28, 2015 at 9:20 AM, Soumyendu Paul > wrote: > >> Dear All, >> >> Please find

Re: $$Excel-Macros$$ Re: Dynamic Combobox in Userform

inkedin.com/profile/view?id=312532939 > > > > > On Tuesday, May 26, 2015 at 1:06:40 PM UTC+5:30, Soumyendu Paul wrote: >> >> Dear All, >> When you click button2 in sheet1,a userform will popup along populated >> combobox with employee Id. My query is when I t

Re: $$Excel-Macros$$ Re: Dynamic Combobox in Userform

Have seen ur attachment will check after going back home On May 27, 2015 4:39 PM, "Mandeep Baluja" wrote: > drop down ??? It's a combo box > > On Wednesday, May 27, 2015 at 4:27:22 PM UTC+5:30, Soumyendu Paul wrote: >> >> Its a drop down with employee code &

Re: $$Excel-Macros$$ Re: Dynamic Combobox in Userform

ps://www.linkedin.com/profile/view?id=312532939 > > > > > On Tuesday, May 26, 2015 at 1:06:40 PM UTC+5:30, Soumyendu Paul wrote: >> >> Dear All, >> When you click button2 in sheet1,a userform will popup along populated >> combobox with employee Id. My query i

Re: $$Excel-Macros$$ Dynamic Combobox in Userform

Any update please. On 5/26/15, Soumyendu Paul wrote: > Dear All, > When you click button2 in sheet1,a userform will popup along populated > combobox with employee Id. My query is when I type 12 all empoyee Id > beginning with 12 should be displayed in combobox. >

$$Excel-Macros$$ Dynamic Combobox in Userform

Dear All, When you click button2 in sheet1,a userform will popup along populated combobox with employee Id. My query is when I type 12 all empoyee Id beginning with 12 should be displayed in combobox. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:O

Re: $$Excel-Macros$$ Dynamic chart between data range

Dear Amar, Sorry for being late. Kindly find the attachment. On Mon, Feb 23, 2015 at 12:10 PM, amar takale wrote: > Dear experts > > I want to update chart as per date change in cell I3 & J3.means between > date range. i think it done by offset formula through name range. > > pls guide me > >

Re: $$Excel-Macros$$ Problem With Timer-inVBA

I have seen it ; look into code after going back home On Feb 2, 2015 3:58 PM, "Vaibhav Joshi" wrote: > Great, pl note i have replaced your code.. > > On Mon, Feb 2, 2015 at 3:53 PM, Soumyendu Paul > wrote: > >> Thanks Vaibhav it's working >> On Fe

Re: $$Excel-Macros$$ Problem With Timer-inVBA

Thanks Vaibhav it's working On Feb 2, 2015 12:23 PM, "Vaibhav Joshi" wrote: > Hi Soumyendu.. > > check this.. > > Cheers!! > > On Mon, Feb 2, 2015 at 10:58 AM, Soumyendu Paul > wrote: > >> Please help!! >> On Feb 2, 2015 7:21 AM, "Soumy

Re: $$Excel-Macros$$ Problem With Timer-inVBA

Please help!! On Feb 2, 2015 7:21 AM, "Soumyendu Paul" wrote: > I have already shared file please see attachment > On Feb 2, 2015 3:27 AM, "Paul Schreiner" wrote: > >> Can you share the file? >> How are you using/displaying a timer? >> >> yo

Re: $$Excel-Macros$$ Problem With Timer-inVBA

are > you using? > > *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 Wesley* >

$$Excel-Macros$$ Problem With Timer-inVBA

I have developed a timer using selection change event. But problem is how to stop timer using command button while timer is runng. please help! File attached -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook pag

Re: $$Excel-Macros$$ last sunday of the month?

Vaibjav, Can u explain your formula? On Thu, Jun 5, 2014 at 1:00 PM, Vaibhav Joshi wrote: > hi > > use formula =INT((EOMONTH(F1,0)-1)/7)*7+1 > > where cell f1 contains any date in that month. > > Cheers!! > > > On Thu, Jun 5, 2014 at 12:55 PM, 'Hanumant' via MS EXCEL AND VBA MACROS < > excel-ma

$$Excel-Macros$$ Query Regarding Range.Dirty

Hi Experts. I have found numerous examples of *Range("E3").Dirty* like standard VBA code in websites. As per their explanation; it forces "E3" cell to recalculate when Excel is manual calculation mode. Could anyone in this group give me an example of practical application of this property?

$$Excel-Macros$$ Join Me

Hi, Please join me in this group Regards, Soumyendu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thr