Re: $$Excel-Macros$$ count tricky question

Len(a1)-len(substitute(a1,a,)) Try see if it works Sent on my BlackBerry® from Vodafone -Original Message- From: danial mansoor danial_...@hotmail.com Sender: excel-macros@googlegroups.com Date: Fri, 18 May 2012 09:48:57 To: excel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ count tricky question

If u want to count total errors then Sum(if(iserror(a1:a10),1,0)) Press ctrl +shift+ enter And if you want to count types of error simply use countif Sent on my BlackBerry® from Vodafone -Original Message- From: danial mansoor danial_...@hotmail.com Sender:

Re: $$Excel-Macros$$ Help with PPT

Can you share the sample data Sent on my BlackBerry® from Vodafone -Original Message- From: B.N.Chethan Kumar chetankumar1...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 19 May 2012 15:35:26 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ help in matching data in excel sheet

Can you send the sample file Sent on my BlackBerry® from Vodafone -Original Message- From: Cute Awesome aqibmari...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 19 May 2012 17:38:06 To: excel-macros@googlegroups.com\excel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ PowerPoint to excel

Can you share ppt and outfile in excel Sent on my BlackBerry® from Vodafone -Original Message- From: alpes...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 14 Jul 2012 20:53:50 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

Save the file in .xlsb format Sent on my BlackBerry® from Vodafone -Original Message- From: Rakesh Kumar Sharma rakeshks@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 16 Aug 2012 13:01:54 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Macro for mail from excel - with sheets as an attachment

http://www.rondebruin.nl/sendmail.htm Sent on my BlackBerry® from Vodafone -Original Message- From: Amit Desai (MERU) amit.de...@merucabs.com Sender: excel-macros@googlegroups.com Date: Sun, 26 Aug 2012 11:41:06 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ How to get Last Saved time in Cell B1

Use before save event And save time in a1 Sent on my BlackBerry® from Vodafone -Original Message- From: Kuldeep Singh naukrikuld...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 7 Sep 2012 12:33:07 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Creating Custom Ribbon

Visit www.rondebruin.nl/ribbon.htm Sent on my BlackBerry® from Vodafone -Original Message- From: t vinay vinaytu...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 11 Sep 2012 22:48:24 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Need Help related to XML with excel

While you are importing use record macro option When u are done click on stop button Press alt +f11 to see the code Sent on my BlackBerry® from Vodafone -Original Message- From: Amol Jadhav asja...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 11 Oct 2012 11:54:30 To:

Re: $$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

Hi Its working fine on my desktop. Can you send the file Also specify which version of office u r using Sent on my BlackBerry® from Vodafone -Original Message- From: prkhan56 prkha...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 13 Oct 2012 12:01:09 To:

Re: $$Excel-Macros$$ VBA code to export from excel to word

Can u share excel file and output in word Sent on my BlackBerry® from Vodafone -Original Message- From: Hilary Lomotey resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 16 Oct 2012 12:40:21 To: excel-macrosEXCEL-MACROS@googlegroups.com Reply-To:

Re: $$Excel-Macros$$

Use application.displayalerts = false Application.screenupdating= false At the beginning of code And turn them true at the end of code before end sub Sent on my BlackBerry® from Vodafone -Original Message- From: Shrinivas Shevde shrinivas...@gmail.com Sender:

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone -Original Message- From: veerendra vanam veerendra.va...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 To: excel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Modify Code to to send range *

Choose In tools ~reference ~ microsoft outlook Sent on my BlackBerry® from Vodafone -Original Message- From: Hilary Lomotey resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 28 Nov 2012 20:12:36 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ convert time formatted as text to military time and join with date field

Can u attach the excel file with sample data Sent on my BlackBerry® from Vodafone -Original Message- From: JenIT jen...@alliedstaffing.com Sender: excel-macros@googlegroups.com Date: Thu, 29 Nov 2012 09:50:18 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Scraping data from image

Try able2extract professional version Or google OCR to word online converters Sent on my BlackBerry® from Vodafone -Original Message- From: Arsfan2005 arsfan2...@yahoo.co.in Sender: excel-macros@googlegroups.com Date: Fri, 30 Nov 2012 12:58:24 To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

have u selected the correct template and extension of template Pls check it once again Sent on my BlackBerry® from Vodafone -Original Message- From: Laura Ann Dietrich ldietri...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 11 Dec 2012 13:09:35 To:

$$Excel-Macros$$ Happy b'day Noorain Ansari

Happy b'day Noorain Ansari Regards Ashish Koul Sent on my BlackBerry® from Vodafone -- 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, Formula

Re: $$Excel-Macros$$ Parts search with filters using a macro

Are you selecting contains option manually? Regards Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: Dan Nichols dannich...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 14 Jan 2013 11:45:44 To: excel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Macro to delete a specific sheet by specifying

Use input box pass the sheet name through inputbox Sent on my BlackBerry® from Vodafone -Original Message- From: Hilary Lomotey resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 29 Jan 2013 12:45:45 To: excel-macrosEXCEL-MACROS@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Getting Email Pattern

Use Fn first name Fni or fi first intial Ln last name Lni or li last name intial Sent on my BlackBerry® from Vodafone -Original Message- From: rajan verma rajanverma1...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 1 Feb 2013 09:59:08 To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ I need excel to find a value in the next row's cell back on the highest value of the previous cell.

Can you share the excel file how would you like to see the output and also if possible make changes in the data of last row thr are two cells with 3% and I think you have to pick first instance Regards Ashish Sent on my BlackBerry® from Vodafone -Original Message- From:

Re: $$Excel-Macros$$ Macro newb - copy rows from multiple workbooks using condition

Can u share some sample input workbooks Sent on my BlackBerry® from Vodafone -Original Message- From: Aikistan stan.mitche...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 27 Mar 2013 08:06:39 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ 8 become 0

Change the format of cell to text or add ' in front of number Sent on my BlackBerry® from Vodafone -Original Message- From: priti verma pritiverma1...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 6 May 2013 16:29:14 To: excel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Not getting daily emails

Check ur google group settings Sent on my BlackBerry® from Vodafone -Original Message- From: PrIyAnKa p.dhamsa...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 5 Jul 2013 14:27:14 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Copy Past Macro help

Hi R u using lotus notes or outlook for sending emails Regards Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: shraddha malvankar shraddhamalvan...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 13 Sep 2013 10:57:37 To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Splitting single browser is possible ?

Can u explain the requirement in details with image of screen if possible Sent on my BlackBerry® from Vodafone -Original Message- From: Abhidha Dixit abhidha.di...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 17 Sep 2013 13:10:57 To:

Re: $$Excel-Macros$$ How to paste a range of cells from excel to text field of a web page

Is it working if u pass a single cell value only Sent on my BlackBerry® from Vodafone -Original Message- From: Menaka Balakrishnamoorthy menaka.balakris...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 21 Sep 2013 08:12:52 To: excel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ I NEED EXCEL CODE TO FORMAT AND SORT THE DATA FROM CONVERTED IMAGE DOCUMENT

Do u want a formula which will convert image into excel ? Regards Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: Mani Manju manisw...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 23 Sep 2013 08:21:17 To: excel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Re: total Fridays in a range

Can u explain it in detail Sent on my BlackBerry® from Vodafone -Original Message- From: asd...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 2 Oct 2013 01:22:20 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re:

Re: $$Excel-Macros$$ VBA for Excel to Word

Can u share sample workbook n output format in word document Sent on my BlackBerry® from Vodafone -Original Message- From: Justin Pulley maverick494...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 16 Oct 2013 10:47:40 To: excel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Stuck in attaching multiple image files in email body

You need to attach the images as well Sent on my BlackBerry® from Vodafone -Original Message- From: Farrukh Shaikh fj.shaik...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 19 Nov 2013 13:10:50 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formula for averaging readings in Excel 2010 column, the odd and the even numbered cells

Its ok You can also try averageif function Sent on my BlackBerry® from Vodafone -Original Message- From: Noel Sherry nshe...@bethel.edu Sender: excel-macros@googlegroups.com Date: Wed, 27 Nov 2013 22:58:45 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Export table data from outlook body to excel files

Hi Ankit Save the outlook mail as word document and then open the document and copy content and paste it in excel You need to automate above steps Sent on my BlackBerry(R) from Vodafone -Original Message- From: Ankit Mehra ankitmehr...@gmail.com Sender: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com

Can u share how output will look like Sent on my BlackBerry(R) from Vodafone -Original Message- From: ashish koul koul.ash...@gmail.com Date: Sun, 9 Mar 2014 22:42:50 To: excel-macrosexcel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

Y don't u use sumifs or countifs Sent on my BlackBerry(R) from Vodafone -Original Message- From: Prabhu Pinky prabhupin...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 17 Mar 2014 15:48:28 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Macro to copy data from a specif range from many closed workbooks in a folder to a master file creat

Can you please let us know if all files saved in a single folder or in multiple folders? Can you please share some dummy files and master file how the output will look like Thanks Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: Dragomir Zhelev

Re: $$Excel-Macros$$ Re: VBA Job @ Ernst and Young , Gurgaon

Pls share ur cv Sent on my BlackBerry® from Vodafone -Original Message- From: kapil Gupta kgupt2...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 21 Apr 2014 04:00:54 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: VBA

Re: $$Excel-Macros$$ Turning repating data in a Row into a sigle column

Can u please share a sample file ? Sent on my BlackBerry® from Vodafone -Original Message- From: Freddy cis9467...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 3 May 2014 20:04:03 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: