$$Excel-Macros$$ Userform for 10 secs

Hi, I have created Userform which will open when the excel sheet opens, but how to keep it only for 10 secs. After 10 seconds it should close automatically. Any macro code for that?? --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Help to break excel sheet password

Hi Nipun, There is not attachement. Pls re-send it. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/6/09, champaneriya nipun wrote: > > Dear All Excel Gurus, > > I need help to recover my passw

$$Excel-Macros$$ Re: code for locking entire row

Hi Vidyut, Sorry for the delay. Please find attached the required solution. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/10/09, vidyut more wrote: > > -- Forwarded message --

$$Excel-Macros$$ Excel VBA macro to filter and delete duplicate rows

Hi Everyone, I am new to excel vba programming. I found this macro goggling. It basically does what I want it to do. However, my data starts on row 6, column A. This macro starts on A1. I have other data above row 6 that I want to keep. This macro messes up the formatting. I can't figure o

$$Excel-Macros$$ Re: Need to sort spreadsheet based on values in Column A

Its fine.just have a chill pill...LOLz Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Thu, Sep 10, 2009 at 11:00 PM, rad...@progressivetel.com < rad...@progressivetel.com> wrote: > > My most humble of apologies... this is correct... I confused myself... ma

$$Excel-Macros$$ Re: Need to sort spreadsheet based on values in Column A

My most humble of apologies... this is correct... I confused myself... many apologies and many thanks! Lee Original Message: - From: Harmeet Singh harmeet.hew...@gmail.com Date: Thu, 10 Sep 2009 02:10:25 +0530 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need t

$$Excel-Macros$$ CHART QUESTION

On Sep 10, 9:15 am, Algo Trading wrote: > Attached please see file which I found online. Sheet 1 has 'Specified > Entries' which allows users to select FROM and TO dates. > > Another sheet " REquirements" I have raw data and would like to do the same > thing but this time I have more columns to

$$Excel-Macros$$ Re: Goto to specific sheet

Since you're asking the question in a VBA macros group, I assume you're looking for the VBA solution. You use: Sheets("sheet1").Select (change "sheet1" to the sheet you want to select) P From: Aamir Shahzad To: excel-macros@googlegroups.com Sent: Thursday,

$$Excel-Macros$$ Re: Urgent_ Need ranking formula

Hey, Sure, here you go! Ramesh On Thu, Sep 10, 2009 at 8:56 PM, vinod rao wrote: > Hello Ramesh, > Can you plz put it in my file and send. That will be great. > > Regards > > On Wed, Sep 9, 2009 at 11:12 PM, Chanti-Hyd wrote: > >> >> {=SUM(IFERROR(1/COUNTIF(rankrng,IF(rankrng>E14,rankrng)),0)

$$Excel-Macros$$ Goto to specific sheet

Hi dear all, I want to know that how I goto specific sheet (sheets are alphabatic order and I know the sheet name) if excel file contains lots of sheet. Regards, Aamir Shahzad --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Re: Urgent_ Need ranking formula

Hello Ramesh, Can you plz put it in my file and send. That will be great. Regards On Wed, Sep 9, 2009 at 11:12 PM, Chanti-Hyd wrote: > > {=SUM(IFERROR(1/COUNTIF(rankrng,IF(rankrng>E14,rankrng)),0))+1} > > I think this formula should work for you.. > > > Thanks, > Ramesh > > > On 9 Sep, 21:28, v

$$Excel-Macros$$ Re: Frnds

J walkenbach books are very good for beginners. Rajesh On Mon, Aug 24, 2009 at 2:05 PM, Shiyas A wrote > Hello Frnds, > > Good Day to u all > > Me a beginner in Excel Macros , can anybody suggest me the best book > available in the market from which i can learn the basics of VB Macros in > Exc

$$Excel-Macros$$ Re: Query

Hi Ankur, Use Ctrl+H, and replace blank with 0. this will solve ur problem, Rgds, Mahender Bisht On Tue, Sep 8, 2009 at 3:10 PM, Ankur Satija wrote: > How to put zero ('0') in Blank Cells scattered in a table? > >> - >> Ankur Satija, Consultant >> > > > > -- With Love, Mahesh Bisht --~-

$$Excel-Macros$$ Re: Lookup Query

use the formula =INDEX(C6:G6,MATCH(LARGE(C7:G7,1),C7:G7,0)) On Tue, Sep 8, 2009 at 12:16 PM, gyanesh jain wrote: > > Hi friends, > I have some Query related with Lookup. its in attachment. > > can any provide the solution? > > -- > Thanks, > Gyanesh Jain, BE, MBA (Finance) > +91 98868 68488 > P

$$Excel-Macros$$ Re: Capture value of new Target

Oops, I meant to remove that line. The problem is with the "OldValue" variable. BTW, OldValue is declared as a string; OldRange is declared as a Range. I don't think I'm using OldRange properly, but that's another issue. Paul Schreiner wrote: > I think I've found the source of your problem. > >

$$Excel-Macros$$ Re: Need to sort spreadsheet based on values in Column A

Hi, This is close to what I am needing. I suspect that I didn't explain what I needed properly. The data in columns B,C and D are already populated. These three fields (BCD) are tied to this one particular reel. My situation is this: Columns BCD are from a report that I can pull that shows this

$$Excel-Macros$$ Re: Urgent_ Need ranking formula

hi Here is the attached file Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Sep 9, 2009 at 9:28 AM, vinod rao wrote: > Hello Team, > > Need ranking formula.See attached, kindly help. > Regards > > > > > > --~--~-

$$Excel-Macros$$ Re: Compare 4 columns in excel spreadsheet

Hi Hope this solves your problem... ALL THE BEST Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Sep 9, 2009 at 7:48 PM, fishbonez wrote: > > i would like to know how can i compare 2 (A & B)cols in sheet 1 to > another