$$Excel-Macros$$ ExcelAutomate.blogspot.in

Hi webies, I just started blogging, please check the excel automation blog www.excelautomate.blogspot.in... please share your comments and more information about excel macros... With Thanks, Anoop.V -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Re: ExcelAutomate.blogspot.in

Please post your questions also On Wednesday, 20 November 2013 14:54:56 UTC+5:30, anoop kumar wrote: Hi webies, I just started blogging, please check the excel automation blog www.excelautomate.blogspot.in... please share your comments and more information about excel macros

$$Excel-Macros$$ Re: ExcelAutomate.blogspot.in

Introduction to VBA programming...guys please check it out http://excelautomate.blogspot.in/2013/11/what-is-vba-writing-your-first-vba.html On Wednesday, 20 November 2013 14:54:56 UTC+5:30, anoop kumar wrote: Hi webies, I just started blogging, please check the excel automation blog

$$Excel-Macros$$ Re: ExcelAutomate.blogspot.in

On Wednesday, 20 November 2013 14:54:56 UTC+5:30, anoop kumar wrote: Hi webies, I just started blogging, please check the excel automation blog www.excelautomate.blogspot.in... please share your comments and more information about excel macros... With Thanks, Anoop.V -- Are you =EXP

$$Excel-Macros$$ Re: ExcelAutomate.blogspot.in

http://excelautomate.blogspot.in/2013/11/10-quick-time-saving-excel-shortcuts.html check for excel short cuts On Saturday, 23 November 2013 14:42:18 UTC+5:30, anoop kumar wrote: Introduction to VBA programming...guys please check it out http://excelautomate.blogspot.in/2013/11/what

$$Excel-Macros$$ Re: ExcelAutomate.blogspot.in

Guys check the most important built-in functions in VBA... http://excelautomate.blogspot.in/2013/11/vbas-most-useful-built-in-functions.html Good night On Wednesday, 20 November 2013 14:54:56 UTC+5:30, anoop kumar wrote: Hi webies, I just started blogging, please check the excel automation

$$Excel-Macros$$ Want help in Automating IE application

Hi, I need to automate a web application, i can pick the HTML Elements and set the values. But I am unable to send the keys like ENTER,TAB into Internet Explorer. I tried different types of send keys options Please help me with answeres With Thanks, Anoop Kumar.V

$$Excel-Macros$$ Re: VBA basic concept

Good Evening Dharam, Please check this blog for simple way of creating VBA macros and functions. www.excelautomate.blogspot.in On Sunday, 24 November 2013 10:12:30 UTC+5:30, Dharm Pd wrote: Dear All, I work in Excel from last 8 years and understand almost all function of Excel but

$$Excel-Macros$$ Re: HYPERLINKS

Hi Mickey, Check these posts for more about hyperlinks http://excelautomate.blogspot.in/2013/11/how-to-create-hyperlinks-in-multiple.html and creating dropdown list of hyper links http://excelautomate.blogspot.in/2013/11/drop-down-list-of-hyperlinks.html On Friday, 22 November 2013 03:31:49

$$Excel-Macros$$ Re: Date format_Not in Proper

Hi Jadhav, Please check here for formats http://excelautomate.blogspot.in/2013/11/using-custom-format-for-numbers-dates.html On Monday, 18 November 2013 12:23:35 UTC+5:30, Prafull Jadhav wrote: Dear All, Good Afternoon ! I have one small query regarding date format . Daily i am getting

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

Hi Excel Fans, My self Anoop Kumar, working as a automation tester. I'm using Excel for my automation activities such as mainframe validation, job submitting, internet explorer automation, report automation etc. Want to know more about automation visit my blog : www.excelautomate.blogspot.in

$$Excel-Macros$$ Re: Formula Error

Hi Rajan, Please check here to understand Excel formulas in detail. http://excelautomate.blogspot.in/2013/11/how-to-work-with-formulas-in-excel.html On Monday, 11 November 2013 15:42:14 UTC+5:30, Rajan sharma wrote: Dear experts, I have wrote formula in the attached file, but throwing

$$Excel-Macros$$ Re: use of find method in VBA

Check VBA's most useful built in functions http://excelautomate.blogspot.in/2013/11/vbas-most-useful-built-in-functions.html On Thursday, 7 November 2013 11:13:59 UTC+5:30, rutuja patekar wrote: I am taking data from one workbook and finding the same data in different workbook. I am using

$$Excel-Macros$$ Re: Excel Macro to print, slecting range, printer and orientation etc

Hi Howard, check this site for learning simple macros in easy ways... http://excelautomate.blogspot.in On Sunday, 27 October 2013 08:26:00 UTC+5:30, Howard Rambin wrote: I am new to macros in Excel (wiz at lotus keyboard macros). I don't have not problem recording a simple print macro with

$$Excel-Macros$$ Re: Data validation - Need help to prevent Duplicate Entry

check here.. http://excelautomate.blogspot.in/2013/11/function-to-find-unique-items-in-list.html On Wednesday, 16 October 2013 20:29:51 UTC+5:30, Excel ka Keeda wrote: Dear Exterts, I am stuck in my project and need your expert advice that ho can i prevent duplicate data entry in any

$$Excel-Macros$$ Re: Re Help with Date probs

Hi Dawns, Check http://excelautomate.blogspot.in/ for more excel tricks On Saturday, 21 September 2013 18:44:29 UTC+5:30, DawnS wrote: This is not actually a question but just a big THANKYOU to the three responses to by prob. Thanks heaps guys! The key just below Esc combined with Control

$$Excel-Macros$$ Sending Email from Excel using VBA

Guys, Want to know how check it out http://excelautomate.blogspot.in/2013/11/sending-email-from-excel-using-vba.html Thanks, Anoop Kumar.V -- 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$$ History of spreadsheets

http://excelautomate.blogspot.in/2013/11/a-brief-history-of-spreadsheets.html -- 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,

$$Excel-Macros$$ Why Excel Is Great for Developer's

Why Excel Is Great for Developer's Check it out http://excelautomate.blogspot.in/2013/12/why-excel-is-great-for-developers.html -- 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$$ Re: Why Excel Is Great for Developer's

http://excelautomate.blogspot.in/2013/12/what-is-spreadsheet-application.html On Tuesday, 3 December 2013 19:00:19 UTC+5:30, anoop kumar wrote: Why Excel Is Great for Developer's Check it out http://excelautomate.blogspot.in/2013/12/why-excel-is-great-for-developers.html -- Are you =EXP

$$Excel-Macros$$ Re: format date untuk excel

check this http://excelautomate.blogspot.in/2013/12/date-functions.html On Monday, 9 December 2013 18:20:30 UTC+5:30, rudi ansyah wrote: untuk merubah format waktu misalnya 01 - des - 2011, tidak bisa berubah ke 01 - 12 - 11, mohon bantuannya. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

$$Excel-Macros$$ Re: VBA to send excel file using outlook

check this http://excelautomate.blogspot.in/2013/11/sending-email-from-excel-using-vba.html On Monday, 9 December 2013 18:13:22 UTC+5:30, Chethan wrote: I have to send excel as attachment to end user. But using different account. Like using from as a Common I'd -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Re: New to Macros - In search of a solution

Matt, check my blog.. i have given simple way to create macros and excel tricks www.excelautomate.blogspot.in On Wednesday, 4 December 2013 02:31:44 UTC+5:30, Matt Watson wrote: Hello all, joined this group today. I like to think I'm quite handy with excel, but the uses are so broad I

$$Excel-Macros$$ Optimizing VBA CODE

http://excelautomate.blogspot.in/2013/12/optimizing-vba-code.html -- 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

$$Excel-Macros$$ what is event programming in EXCEL using VBA

http://excelautomate.blogspot.in/2013/12/introduction-event-programming-is-very.html -- 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

$$Excel-Macros$$ How to declare variables

http://excelautomate.blogspot.in/2013/12/declaring-variables.html -- 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

$$Excel-Macros$$ what is defined names in Excel

http://excelautomate.blogspot.in/2013/12/introduction-to-defined-names.html -- 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,

$$Excel-Macros$$ 10 Quick Time-Saving Excel Shortcuts Mouse Tricks

http://excelautomate.blogspot.in/2013/11/10-quick-time-saving-excel-shortcuts.html -- 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,

$$Excel-Macros$$ Calling Worksheet Functions From VBA

http://excelautomate.blogspot.in/2013/12/calling-worksheet-functions-from-vba.html -- 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,

$$Excel-Macros$$ Introduction to Array Formulas

http://excelautomate.blogspot.in/2013/12/introduction-array-formulas-are.html -- 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,

$$Excel-Macros$$ Lookups and Tables

http://excelautomate.blogspot.in/2013/12/lookups-and-tables.html -- 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

$$Excel-Macros$$ Re: Conditional Format

please see this site about how to write excel formulas http://excelautomate.blogspot.in/2013/11/how-to-work-with-formulas-in-excel.html On Friday, 13 December 2013 05:31:13 UTC+5:30, Troy Nieto wrote: I want to display in E8 Complete if D8 has a strikthrough format in the cell, otherwise

$$Excel-Macros$$ Re: Images in Excel - Prints Differently Than Displayed in Worksheet

check www.excelautomate.blogpsot.in On Wednesday, 11 December 2013 21:22:04 UTC+5:30, Brian Keith wrote: I am copying an image to an Excel worksheet, and then sizing to the scale I want and placing it where I want the image to show up in the worksheet upon printing. What happens though is

$$Excel-Macros$$ Re: VBA macro to replace Index and Match formula

you can try conditional formatting option, like select the columns you want to compare or find duplicates. and go to conditional formatting highlight the duplicate cell it will give the correct answer. for Excel Automation visit

$$Excel-Macros$$ Re: vlookup help.

check this prabhu http://excelautomate.blogspot.in/2013/12/lookups-and-tables.html On Sunday, 24 November 2013 11:32:00 UTC+5:30, Prabhu Pinky wrote: Hi Experts, How to do vlookup in VBA. i have two sheets saved in different locations. i need to do vlookup in sheet1 by referring another

$$Excel-Macros$$ Re: Vlookup query

shrini check this http://excelautomate.blogspot.in/2013/12/lookups-and-tables.html On Wednesday, 20 November 2013 17:10:46 UTC+5:30, shrini wrote: Dear All Please find attached query. Is it possible to write aformula as per my requirement -- Shrini -- Are you =EXP(E:RT) or