$$Excel-Macros$$ Class Module

Hi everyone Could any one help with an example of using Class module in Excel/VBA Regards Sivakumar --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tut

$$Excel-Macros$$ Re: VBA

Use google to search VBA codes. there are lot of website, ebooks, forums and help available. Each time you have a task in head, try to VBA to resolve it once and all. So, each day you learn new things. I learnt it this way.. Regards, Sarfaraz Ahmed Microsoft Excel help

$$Excel-Macros$$ Re: Getting top 50 ranks from a pivot table

Hi All, I am new for VBA.But i am working as developer in Java Tech. Please suggest me how to learn VBA ? -- Regards, Jai Deo Tiwari, Rewire Information Systems Indiranagar, Bangalore - 38 Mob # 09620346991 . Notice: The information contained in this e-mail message and/or attachments to it

$$Excel-Macros$$ Re: Date Format

Hi Kaustubh, Sorry I missed the mmdd part of your query. By the way Paul's solution is working great! Attached is a sample file. Brgrds On Tue, Sep 29, 2009 at 9:10 PM, Kaustubh K wrote: > > Hi Abhishek, Thanks for your reply ! But there is one problem. Suppose > I have date 5.6.08 ( June

$$Excel-Macros$$ VBA

How to learn VBA I am new to VBA ,can anybody suggest me the ways to learn VBA Sumanth. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video

$$Excel-Macros$$ Re: Date Format

Hi Kaustubh, Follow These steps. 1.Add two new columns next to the column containing date(say column A). 2.Select column A (column contining date) then goto Data>Text to Columns.. 3.Click on Delimted option then Next 4.Uncheck Tab option in Delimters and check other: and write '.

$$Excel-Macros$$ Doubt

1)Can anybody suggest me how tomopen multiple worksheets in Excel by using single command 2) Could you please provide Interview questions on Advanced Ms-excel and VBA Thank you Sumanth. --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Puzzle #3 - Identify Perfect and Smith Numbers

Well done its helpful for me On Wed, Sep 30, 2009 at 12:20 AM, Sandeep wrote: > Hello Everyone, > Here is solution for Puzzle#3 NOT PROTECTED, so enjoy it. Hello Vivek I was > aspecting more puzzles from you as per you said but waiting is seems as it > never ends. Please give some more puzzles.

$$Excel-Macros$$ Re: 2 FILTER IN SINGLE SHEET

Hi, I wanna tell you that fillter work in nested (One inside another) manner. Means after you apply one filter on a data the remaining data is according to you filter criteria. After this if you apply another filter ( Without removing the first one) then the filter is according to your first cr

$$Excel-Macros$$ Re: Date Format

Hi Abhishek, Thanks for your reply ! But there is one problem. Suppose I have date 5.6.08 ( June 5, 08). If I replace . by / then I ll get 5/6/08 date format is mmddyy and my date will change and it will be May 6,08. On Sep 28, 3:02 pm, Abhishek Jain wrote: > Easy and simple - > > Select your co

$$Excel-Macros$$ Re: Date Format

Hi Paul, Thanks for your reply. I tried this. It is showing #VALUE! On Sep 28, 4:26 pm, Paul Schreiner wrote: > since the values are always 2 characters, > you could add a column and use: > > =DATEVALUE(MID(A2,4,2)&"/"&LEFT(A2,2)&"/"&RIGHT(A2,2)) > > hope this helps > > Paul > > ___

$$Excel-Macros$$ Re: Adding columns value from multiple files from a folder

Hi Kunal, See this thread. Adopt the code to suit you. http://groups.google.com/group/excel-macros/browse_thread/thread/61b820c5df194b14# Kris On Sep 26, 4:09 pm, kunal wrote: > Hi, > > I am stuck at this point. I need to add a range from a particular column > from all excel sheet present in

$$Excel-Macros$$ Re: Unique record retrieval

Hi, If you want to retrieve a unique row then select all data go to 'Advance filter' and check 'unique records only'. Choose 'Filter the list, In place' if you want to just filter the data and choose 'Copy to another location' if you want to copy the filter list to another place, (select any blank

$$Excel-Macros$$ Getting top 50 ranks from a pivot table

Hi Group, I Have a Pivot table with Ranks data. Now i want to get Column wise 1.Top 50 Ranks(Only), 2. their title, 3.Country and 4.date. Please let me know if you want it in the excel sheet for better understanding. Can you guys help me with this. Thanks In Advance Prashanth --~--~-~

$$Excel-Macros$$ Re: Getting top 50 ranks from a pivot table

Hi Prashanth, If the pivot table shows that data in column G, then you can use the following formula:- =LARGE(G:G,COUNTA($G$1:G1)) Note:- Drag it to 50 times down. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062

$$Excel-Macros$$ Re: vba password

*Hi Shefali,* There are many softwares available on the web to crack the VBA password, alternatively you can navigate the web posts of this group to search for an application, as I have seen some users shared some download links of some softwares. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hon

$$Excel-Macros$$ Re: When some data is filtered how to find unique values in excel

Hi Vikas, Yes there is a way to get the unique items by the use of filter. you have to follow the steps below Go to filter advance filter, check the unique filter check box, in the list range select the list from where you have to fetch the values, and select copy to another location and click o

$$Excel-Macros$$ Re: Converting data into date

Hope below code helps: *Cells(1, 1).Value = Format("23-Mar-2009", "/mm/dd")* * * * *Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Mon, Sep 28, 2009 at 10:39 PM, Duncan - UK wrote: > > Hi there, > > Fairly new to VBA. > > I am trying to convert a column (header is date) in

$$Excel-Macros$$ Re: When some data is filtered how to find unique values in excel

Used Find option. On Tue, Sep 29, 2009 at 10:40 AM, Vikas Agarwal wrote: > Dear All, > > Need a small help. > > Is there a way to find unique values in excel when some data is filtered. > > Eg: > > There are 1-100 rows in a particular sheet > > If the filter contains some 20 odd rows based on ce