Re: $$Excel-Macros$$ Web Query Problem / Need Small Macro

I can see the connection string in Connection tab which refreshes in every one minute. The changes you demand are needed to be written in VBA script as this one is system generated which needs modification. Make a new QT for your connection. - Regards, Anoop Sr. Developer -- Join official Facebo

Re: $$Excel-Macros$$ using VBA to hide a chart object in a worksheet based on conditions from a cell

never mind team. I figured it out. :) Thanks On Sun, Nov 25, 2012 at 9:17 PM, Mog Godiva-Man wrote: > Hi Team, > > does anyone know how to use vba code to control a "chart object" basically > i will like to hide or unhide a chart object. > > thanks in advance. > > -- > Join official Facebook pa

$$Excel-Macros$$ using VBA to hide a chart object in a worksheet based on conditions from a cell

Hi Team, does anyone know how to use vba code to control a "chart object" basically i will like to hide or unhide a chart object. thanks in advance. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor t

Re: $$Excel-Macros$$ Dynamic calendar quiz : There is a prize for the winner.

Submitted. Regards, Vinay Gupta On Sun, Nov 18, 2012 at 9:53 PM, Ayush Jain wrote: > Dear members, > > Let's get set for the new year 2013 > > Here is inviting you to participate in a quiz to make calendar for the new > year in excel. > > There are some rules to be followed : > 1) No macros to b

$$Excel-Macros$$ Offset tutorial required

Offset tutorial required *Dear Experts!!* *can you share any one different criteria's used in offset function and sumproduct function in excel... * * * *thanks* * * -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate

Re: $$Excel-Macros$$ ***Compare 2 sheets***

Hi, Anyone can help with macro? On Sat, Nov 24, 2012 at 11:19 PM, Prabhu wrote: > > > On Saturday, November 24, 2012 8:47:54 PM UTC+5:30, era_kar wrote: > >> Hi, >> One way is finding the matching cells, by copying sheet3 in sheet1 and >> run the program.In column "H" Available are matching ce

$$Excel-Macros$$ Re: Introduce Yourself !!

hi sir my query is i have extract last five yrs data of two stocks and one index on one sheet and prepare line chart and insert four combo boxes 1) stock 1 2) stock 2 3) Index 4)time combo box which incudes if you drag , less than one year .less than than 6 months,2 year,3 year so on and

RE: $$Excel-Macros$$ want tips

Press ALT+ E + K See if any linked workbook Is there Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SAJID MEMON Sent: 25 November 2012 9:01 To: Sundarvelan Natarajan Subject: $$Excel-Macros$$ want

RE: $$Excel-Macros$$ Formula Quiz

Only one drawback is that you use count function , if any entry is text then formula will fail, so just use countA instead of count, although your previous solution is giving correct answer on this situation Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroup

RE: $$Excel-Macros$$ Formula Quiz

Excellent J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of >>Excel Beginner<< Sent: 25 November 2012 12:23 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula Quiz Hi Rajan si