Re: $$Excel-Macros$$ Data Logic

Hi Al, Please find the attached file for your required solution. Regards Sandeep On Thu, Jul 15, 2010 at 5:46 AM, Al wrote: > > Dear All: > > > This is the sample spread sheet i have. > >  pat meds stdt spdt >  111 ABC 1 . >  111 CDE 130 150 >  111 NNN 132 140 >  111 GHI 160 170 >  111 LMN 165

Re: $$Excel-Macros$$ Finding a cell based on multiple criteria typed into cells

Hi David, Please find the solution you required. Feel free to ask anything from me. Regards Sandeep On Wed, Jul 14, 2010 at 3:11 PM, Sach1810 wrote: > Hi, I have a table of data giving different prices of different items. > Below is a sample of that data. I want to be able to type in teh > crit

RE: $$Excel-Macros$$ Using Excel to Control Shapes Drawn In A Workbook

Thanks Anish. Dave. > Date: Thu, 15 Jul 2010 18:24:24 + > From: anish@gmail.com > Subject: RE: $$Excel-Macros$$ Using Excel to Control Shapes Drawn In A > Workbook > To: excel-macros@googlegroups.com > > Hi Dave, > Thanks from me too. Never ever thought tht we could do this too. AUTOM

RE: $$Excel-Macros$$ Help me add a loop.

Hi, I sent a reply to this email a while ago. But when I went to resend it today, I found some errors which are now fixed. I also removed some lines of code which weren't necessary. I've modified your macro below. I've used For Each / Next to loop through each cell in the UsedRange, and Like

$$Excel-Macros$$ Help me add a loop.

Please help asap! I really appreciate it. The code below will search through other worksheets and copy and paste back the search criteria to the next line of a "report" worksheet. It works well except that it only does the first hit in each worksheet and I need it to find multiple. I think alls

$$Excel-Macros$$ HTMLDocument

I would like to add a list item to an html control from Excel VBA using the HTMLDocument model. I have been able operate on text boxes, buttons, but not been able to add an item to a control (i.e. standard html control). I can't find any decent documentation on the HTMLDocument, so any assistanc

Re: $$Excel-Macros$$ Using Excel to Control Shapes Drawn In A Workbook

Great Code. Thank you On Jul 13, 6:54 am, Dave Bonallack wrote: > Hi, > > The attached contains a basic event macro. Change any cell in the range A1:A4 > to change the rectangle's size and position. > > You may be able to adapt it for your own needs. > > Regards - Dave. > > > > > > > Date: Mon,

RE: $$Excel-Macros$$ Using Excel to Control Shapes Drawn In A Workbook

Hi Dave, Thanks from me too. Never ever thought tht we could do this too. AUTOMATION rocks man. Way to learn folks, stick regularly to the group and learn frm experts here. Thanks again Dave, -Original Message- From: Aindril De Sent: 15/07/2010 11:39:34 pm Subject: Re: $$Excel-Macros

RE: $$Excel-Macros$$ Using Excel to Control Shapes Drawn In A Workbook

My pleasure. Dave. Date: Thu, 15 Jul 2010 23:39:34 +0530 Subject: Re: $$Excel-Macros$$ Using Excel to Control Shapes Drawn In A Workbook From: aind...@gmail.com To: excel-macros@googlegroups.com Thanks Dave... This opens a new angle of experimenting with Excel for me... Cheers!! Andy On

Re: $$Excel-Macros$$ Using Excel to Control Shapes Drawn In A Workbook

Thanks Dave... This opens a new angle of experimenting with Excel for me... Cheers!! Andy On Thu, Jul 15, 2010 at 9:53 PM, Vijay Aggarwal wrote: > Hi Dave, > > It's really amazing!!! > > How could u do this?? > > > regards, > Vijay > > On Tue, Jul 13, 2010 at 4:54 AM, Dave Bonallack > wrote: >

Re: $$Excel-Macros$$ Count months

Dear Nadine, Assuming cell A1 has Apr-Jun. In Cell B1 you can type =MONTH(1&RIGHT(A1,3))-MONTH(1&LEFT(A1,3)) to get the desired result. Cheers, Andy On Thu, Jul 15, 2010 at 10:43 PM, Nadine S wrote: > If a cell says Apr - Jun what formula is there to count how many months > that is? The month

RE: $$Excel-Macros$$ How we can open 2007 file in 2003.

group at http://groups.google.com/group/excel-macros/subscribe __ Information from ESET Smart Security, version of virus signature database 5281 (20100715) __ The message was checked by ESET Smart Security. http://www.eset.com -- --

$$Excel-Macros$$ Count months

If a cell says Apr - Jun what formula is there to count how many months that is?  The month range is in one cell and the formula would be in another.  Thanks. Nadine -- -- Some important links for excel use

Re: $$Excel-Macros$$ Using Excel to Control Shapes Drawn In A Workbook

Hi Dave, It's really amazing!!! How could u do this?? regards, Vijay On Tue, Jul 13, 2010 at 4:54 AM, Dave Bonallack wrote: > Hi, > The attached contains a basic event macro. Change any cell in the range > A1:A4 to change the rectangle's size and position. > You may be able to adapt it for y

$$Excel-Macros$$ Show a Form in VSTO Excel

I am new in VSTO and have a doubt. I´ve created a project using VS2008. This is a VSTO in fact. I have a workbook with sheets and I would like to show a form with controls when this workbook is opened and manipulate the sheets data in the events of the controls which are in the form. If someone h

RE: $$Excel-Macros$$ How we can open 2007 file in 2003.

Hi Vijay, you can download the official microsoft converter from it's website. Only after doing that u will be able to open 2007 files in 2003. Just google for 'excel2007 to 2003 coverter'. I HOPE IT HELPS- Regards- ANISh -Original Message- From: Vijay Aggarwal Sent: 15/07/2010 6:08:1

$$Excel-Macros$$ Re: How we can open 2007 file in 2003.

Look at Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats Link: http://www.microsoft.com/downloads/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en Hope this help. On 15 jul, 09:38, Vijay Aggarwal wrote: > Hi All, > > If I am receiving a

Re: $$Excel-Macros$$ How we can open 2007 file in 2003.

install office 2007 compatibity pack for office 2003: http://www.microsoft.com/downloads/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en Thanks, On Thu, Jul 15, 2010 at 6:08 PM, Vijay Aggarwal wrote: > Hi All, > > If I am receiving a file in excel 2007 (***.xlsx) then

$$Excel-Macros$$ How we can open 2007 file in 2003.

Hi All, If I am receiving a file in excel 2007 (***.xlsx) then how can I open that file in excel 2003 (***.xls). Regards, Vijay Kumar Aggarwal 048542 -- -- Some important links for excel users: 1. Follow us on T

RE: $$Excel-Macros$$ Excel macro undefined variable

Hi, Two things I can think of. 1. In the VBA editor, you will see an Edit menu, in which is a Find option. Enter BranchLine into that and see if it finds something you've missed. 2. Put a message box just before the first mention you can find of BranchLine: Msgbox = BranchLine and see what p

RE: $$Excel-Macros$$ Pdf of Excel Macro

Thanks Neil . Regards, C.G.Kumar AMW-2 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of neil johnson Sent: Thursday, July 15, 2010 10:22 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pdf of Excel Macro Hi Everyone, Please

Re: $$Excel-Macros$$ Data Logic

Hi, Add week columns adjucent to stdt, spdt eg. week21, week22 use the IF function for each week and return 1 if the dates fall within the week. (eg. if(stdt <127 and (spdt > 156 or isblank(spdt)) ,1,0) repeat this for each week. then use the DATA -> SUBTOTALS COMMAND to get pat wise subtotals or

$$Excel-Macros$$ Break MS Excel password

Hi Team Please send me software to break the password of MS excel worksheet. Regards, Rajender Soni | +91 750 322 55 50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

Hi, You can use iserror() function to find out any errors. You can use If() function to replace error values to zeroes. use the following formula in adjucent column/row of the actual values that you want to sum eg. you want total the values in column C, then use this formula in column D =IF(IS

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

=SUMIF(C456:F456,"<>#N/a") or =SUMIF(C456:F456,"<0")+SUMIF(C456:F456,">0") regards ashish koul akoul.blogspot.com On Thu, Jul 15, 2010 at 11:27 AM, preeti vora wrote: > > Hi > > is that any formula when we do sum formula but some time in our data #N/A > in list that's WY we not able to see

Re: $$Excel-Macros$$ Outlook Problem

thanks!! yar On Thu, Jul 15, 2010 at 10:05 AM, Chandra Gupt Kumar < kumar.bemlmum...@gmail.com> wrote: > Yes. You can schedule the time of Message. First go to message option > and then select the delivery option. Enter the date and time after which > you want the message to be sent and save.