$$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

$$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?

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 v...@vabs.in wrote: Great, pl note i have replaced your code.. On Mon, Feb 2, 2015 at 3:53 PM, Soumyendu Paul soumyendu...@gmail.com wrote: Thanks Vaibhav it's working On Feb 2, 2015 12:23 PM

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

Thanks Vaibhav it's working On Feb 2, 2015 12:23 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Soumyendu.. check this.. Cheers!! On Mon, Feb 2, 2015 at 10:58 AM, Soumyendu Paul soumyendu...@gmail.com wrote: Please help!! On Feb 2, 2015 7:21 AM, Soumyendu Paul soumyendu...@gmail.com wrote

$$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

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

* - *“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* - *From:* Soumyendu Paul

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

Please help!! On Feb 2, 2015 7:21 AM, Soumyendu Paul soumyendu...@gmail.com wrote: I have already shared file please see attachment On Feb 2, 2015 3:27 AM, Paul Schreiner schreiner_p...@att.net wrote: Can you share the file? How are you using/displaying a timer? you said you're using

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 amartak...@gmail.com 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

$$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 @

$$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

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

Thanks for help On Jun 3, 2015 4:43 PM, Soumyendu Paul soumyendu...@gmail.com wrote: -- Forwarded message -- From: Soumyendu Paul soumyendu...@gmail.com Date: Jun 3, 2015 4:21 PM Subject: $$Excel-Macros$$ Query (Outlook VBA) To: excel-macros@googlegroups.com Cc: Hi, I

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

/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 type 12 all empoyee Id beginning with 12 should be displayed in combobox

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 rockerna...@gmail.com 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 On May 27, 2015 10:29 AM

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

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

$$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

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

Any update please. On 5/26/15, Soumyendu Paul soumyendu...@gmail.com 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$$ 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 @

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

Is there anyone to help? On Tue, Aug 4, 2015 at 10:43 AM, Soumyendu Paul soumyendu...@gmail.com 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 page

$$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$$ 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

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

Access, select - Never warn me about suspicious activity HTH, Abhishek On Tue, Aug 4, 2015 at 2:12 PM, Soumyendu Paul soumyendu...@gmail.com wrote: Hi, How to remove Outlook Security Alerts without using Application.wait Sendkeys Regards, Soumyendu -- Are you =EXP(E:RT

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

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

$$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 @

$$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 @

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 <soumyendu...@gmail.com> 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 V

$$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

$$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

$$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

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