Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Hey There is no password, I opened it without password. Regards Sumit On Tue, Nov 9, 2010 at 3:03 PM, Upendra Singh Sengar upendrasinghsen...@gmail.com wrote: Hi Ayush, What is the password to opent the file. (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Hi Sumit, Kindly mail me the PDF u've downloaded. (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 9 November 2010 15:22, sumit kumar sagars...@gmail.com wrote: Hey There is no password, I opened it without password. Regards Sumit On Tue,

$$Excel-Macros$$ small help

hi friends plz find the attached sheet in which i want a formula in which if i enter the month it should give no. of days of a month in the next column. please help me out -- Sidhu -- -- Some important links for

Re: $$Excel-Macros$$ small help

Dear Sudarshan Please see the attached file with the solution. On Tue, Nov 9, 2010 at 1:06 PM, sudarshan rampe sidhu...@gmail.com wrote: hi friends plz find the attached sheet in which i want a formula in which if i enter the month it should give no. of days of a month in the next column.

Re: $$Excel-Macros$$ array sort issue

First of all... You would think that Application.WorksheetFunction would apply to ALL worksheet functions. But in reality, it does not. ONLY those WorksheetFunctions that were written in a manner accessible to VBA are available.  It's something about the environment where they were developed.

Re: $$Excel-Macros$$ array sort issue

Hi Ted, Instead of Excel.WorksheetFunction.Len just use Len. So your code would look like: iLen = Len(ary(iLoc)) Len function is available as VBA function too, so you don't need to use excel function. This is same as you are doing for conditional statement, IF. Note: The moment you press .

$$Excel-Macros$$ Re: is there a printer installed on this computer?

Hi Omar, There are 2 ways: 1. You can get the printer name using Application.ActivePrinter So, if there is no printer installed, skip through the code. 2. Error Handling to check printer installed or not On Error GoTo RESCUE Activesheet.printpreview

$$Excel-Macros$$ Re: Delete values within an array

Hi Matt, That's Great. We're our best teachers. Kudos :) Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com

Re: $$Excel-Macros$$ Re: Help Required!

Hi, I have attached a spreadsheet which contains list of document numbers and their respective names. What I want is I need a word macro that will do the following. Note: The file name will always starts with the Doc Number (5 digits). Ex: 12345 (Refer Sample_Findlaw.xls for list of Doc Number)

$$Excel-Macros$$ Conditional Formatting

Conditional Formatting You can use something called Conditional Formatting in your spreadsheets. Conditional Formatting allows you to change the appearance of a cell, depending on certain conditions. What we'll do is to colour the Overall Averages on our Student Exam spreadsheet, depending on

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Hi Ayush, Thanks a ton.. for the effort.. Something seems to be wrong at my end as the link you have given is not opening.. Is there any way you can send the file to me plz.. Cheers, Andy On Mon, Nov 8, 2010 at 7:35 PM, Ayush jainayus...@gmail.com wrote: Dear Group Members, Good news for

Re: $$Excel-Macros$$ Conditional Formatting

Great info... Thanks for sharing keep it up.. On Tue, Nov 9, 2010 at 7:01 PM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Conditional Formatting You can use something called Conditional Formatting in your spreadsheets. Conditional Formatting allows you to change

$$Excel-Macros$$ Re: Excel_tips

Thanks Viju for sharing these tips. Great. Keep it up :) Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com

$$Excel-Macros$$ Re: Spreadsheet screen refresh is very slow AFTER macro runs

Hi Mike, Can you notice and send the back the change in Memory Usage by Excel application before and after running the macro? You can locate it in Task manager. You can try clearing clipboard(Application.CutCopyMode = False) to experiment harmlessly.

$$Excel-Macros$$ Macro copy /paste cell content if found

Hi, The following code will split the content in column K by using | as a border key, but would like place another condition to move the cells in different columns based on the character found in the cell. Sub Split_content() Dim objRange1 As Range 'Set up the ranges Set

$$Excel-Macros$$ Column Widths

First attempt at this, so hopefully this is how it works I have a spreadsheet with about 25 tabs and about 200 columns with lots of different widths. As its updated by many the widths get moved about. Before it is released, I run a macro to go through each column in each tab and restore it to

Re: $$Excel-Macros$$ Column Widths

There's lots of ways to accomplish this. Some will depend on the version of Excel that you're using. I have Excel 2007. My first suggestion is: Create a template sheet with the desired column widths and hide it. Then, your macro can unhide the template, select row 1 Copy to the clipboard Loop

Re: $$Excel-Macros$$ Fwd: User form

2010/11/9 neil johnson neil.jh...@googlemail.com Hi, I make textbox in user form. The label of this texbox email . When i enter the email address with out using or forget @ and Dot(.). It should give me msg . please use valid email Id . Wht will be code of this . Please find the

$$Excel-Macros$$ Help: Using SUMIF(S) Function

Hello Excel Gurus, I encountered a challenge on using SUMIF FUNCTION. Help me on summing total amount in different months into different cells. See attached fine for details. -- -- Some important links for excel

Re: $$Excel-Macros$$ Help: Using SUMIF(S) Function

hi, Check this website hope you will find the resolution http://www.homeandlearn.co.uk/excel2007/excel2007s6p4.html Thanks, Raj On Tue, Nov 9, 2010 at 11:19 PM, janet dickson janetdicks...@gmail.comwrote: Hello Excel Gurus, I encountered a challenge on using SUMIF FUNCTION. Help

Re: $$Excel-Macros$$ Help: Using SUMIF(S) Function

Hi, Write following formula beside date column, i.e. In cell C4: =text(B4,mmm) Now copy this formula in all rows of coloumn C, You will get Month name like Aug in cell C4. Now you can use sum if. Sent on my BlackBerry® from Vodafone -Original Message- From: janet dickson

Re: $$Excel-Macros$$ Re: is there a printer installed on this computer?

Yup Omar, you're right. In your case it will be SUB PAGE_SETUP() On Error GoTo RESCUE '*PAGE SET UP LINES* '* '* '*HEADER FOOTER 'REST CODE OR EXIT SUB RESCUE: ' Your code if error 'RESUME NEXT (if