Re: $$Excel-Macros$$ Re: On Time

Hi, I mean that this query has been solved n replied in this forum itself. Please search in this group to get the solution. Best regards, DILIPandey On 11/23/10, Chandra Shekar wrote: > Hi Dilip, > > This is my first post in this forum. I have posted this query in other forum > but I did'nt get

$$Excel-Macros$$ Excel VBA made easy : Cool Stuff for VBA beginners.

Dear members, I hope you are using this platform very well by helping others and reading solutions. I would like to share some material for people who want to understand Excel VBA - but can't get started. I have worked with John Franco (A great excel enthusiast) to get some material of VBA Macros

$$Excel-Macros$$ "How to Record Macros that works" eBook free download

Dear Group, Now you can download VBA macros ebook worth $45 for free. Here is the link to download :- http://recordexcelmacro.com/discussexcel.html Please do not miss the chance to download the eBook. This eBook has 140 pages of valuable knowledge on recording macros and customize them. Feel fr

Re: $$Excel-Macros$$ Long-waited Excel VBA coaching program is live...its worth paying

Dear Group, I hope you are doing well! Thanks to the members who subscribed for this program and giving encouraging feedback about it. :) The program really went well looking at the response. For those who have missed the deadline of $100 discount still have the chance to get $30 discount. The M

$$Excel-Macros$$ Wrong named range being deleted

I have a simple macro that deletes a workbook scoped named range with the name "test". The macro seems to work in most cases except when the workbook also contains a worksheet scoped named range with the same name. Steps to reproduce: 1. Create a new workbook 2. Go to Sheet2, select several cells

Re: $$Excel-Macros$$ Nonlinear Regression Analysis

Hello, Thanks for your response! Here's a random sampling of the data: 169 140 10 164 197 19 50 339 31 73 326 19 204 238 34 143 201 18 59 74 3 296 216 20 31 121 9 108 148 7 139 317 24 41 263 14

$$Excel-Macros$$ Text areas in shapes shown in graphs

We have an Excel 2003 sheet and graph available on demand for folks who subscribe to our dashboard. We have a requirement to generate an Excel sheet and graph depicting either dollar sales or units sold based on user-selected filters available on an HTML launch page. (The data retrieval and Excel

Re: $$Excel-Macros$$ Re: On Time

Hi Dilip, This is my first post in this forum. I have posted this query in other forum but I did'nt get reply for that. Please let me know how to do this. Thanks On Tue, Nov 23, 2010 at 8:53 PM, Dilip Pandey wrote: > Hi, > > I believe this query has been answered in some other posting having >

$$Excel-Macros$$ Excel trainers?

Hi Guys, Anyone here who is expert & ready to take online training for advance excel? Training via skype of yahoo video chat will be better. Any suggessions OR recommendations to discuss further details?Also if anyone of you are expert in econometric modeling OR you know anyone, it would be grea

Re: $$Excel-Macros$$ two database in one file which can open with two password

Hi Rajesh, If you are talking in terms of Excel, then use the following path:- Tools -> Protection->Allow users to Edit Ranges In this you can have different passwords for different ranges. Additionally you can also show or hide sheets and protect and un-protect them using passwords. Workbook pa

Re: $$Excel-Macros$$ Re: On Time

Hi, I believe this query has been answered in some other posting having different subject line. Best Regards, DILIPandey On 11/22/10, Chandru wrote: > Hi, > > Any help please > > Chandra Shekar wrote: >> Hi, >> >> When I run the program excel starts flicekring how to avoid this. >> >> Thanks >>

Re: $$Excel-Macros$$ Nonlinear Regression Analysis

Hi Bob, This seems to be interesting to me. Would you mind providing some sample data with the the indicative result which you want to obtain through Excel. Best Regards, DILIPandey On 11/23/10, Bob wrote: > Good afternoon, > > I have a fairly large data set (roughly 7,000 samples) on which I

Re: $$Excel-Macros$$ On Time

Hi Chandra, You can use following codes at the start of your macro after sub(). Application.ScreenUpdating=False Application.DisplayAlerts=False Application.EnableEvents = False Remember to get them TRUE at the end as well. Best Regards, DILIPandey On 11/19/10, Chandra Shekar wrote: > Hi, > >

Re: $$Excel-Macros$$ On Time

I'm not sure what your macro is doing, but if it is updating data, or changing sheets, then the display is updating. Try using: Application.screenupdating = false at the beginning of your macro and: Application.screenupdating = true at the end. Paul > >From: Chandra Shekar >To: excel-macr

Re: $$Excel-Macros$$ Zooming of Excel Sheet.

can also be done by Ctrl+scroll mouse up/down... Rgds, On Tue, Nov 23, 2010 at 4:03 PM, kiran Kancharla wrote: > U need to change the options. > > Tool ---> Options --> General "Zoom on roll with Intellimouse" > > This has to Uncheck. > > > please try and let me know. > > > > > On Tue, Nov 23,

Re: $$Excel-Macros$$ On Time

Hi, Thank you for the reply, if I run this macro excel will start flickering. How to stop this please run the program and see. Thanks Regards, Chandra Shekar On Tue, Nov 23, 2010 at 1:50 PM, SUMIT VYAS wrote: > find herewith > > > thanks > > sumit > > > On Mon, Nov 22, 2010 at 4:29 PM, Chandr

Re: $$Excel-Macros$$ Zooming of Excel Sheet.

U need to change the options. Tool ---> Options --> General "Zoom on roll with Intellimouse" This has to Uncheck. please try and let me know. On Tue, Nov 23, 2010 at 10:42 AM, C.G.Kumar wrote: > Is it not possible that MS Excel control has changed. > > > On Tue, Nov 23, 2010 at 10:09 AM,

Re: $$Excel-Macros$$ On Time

find herewith thanks sumit On Mon, Nov 22, 2010 at 4:29 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > Any help please > > Thanks > > On Fri, Nov 19, 2010 at 6:07 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Hi, >> >> When I run the program excel start