$$Excel-Macros$$ Re: Help! - Code Module, Protected project, Import code, link to web site, Decrypt,

2009-09-23 Thread Hemant
No Replies! :( On Sep 19, 2:44 pm, Hemant hemantbales...@gmail.com wrote: Good day friends :) I have an excel workbook with one of its hidden (XlVeryHidden) sheets contains a link to my web site and gets updated every time the workbook is opened and once in 15 minutes. When I will publish

$$Excel-Macros$$ Re: Help Required in Master file to PPT

2009-09-23 Thread Nagendra Modupalli
Hi Team, Can you please help me below my request.Thanks in advance On Tue, Sep 22, 2009 at 4:11 PM, minimaster hartmut.gruenha...@bakerhughes.com wrote: How can I attach an excel workbook to this reply? I added some macro code to your workbook. But for some reason I can't find a way to

$$Excel-Macros$$ shortcut key needed

2009-09-23 Thread Alok Bhatt
Hi friends, Can u provide me any shortcut key for proper and upper function in Excel --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and

$$Excel-Macros$$ Re: Fwd: Name Matching In Excel

2009-09-23 Thread Sandeep Kumar Maurya
Hi Sonal, I take a look on your data and find that your data in file1 and file2 are not same as there are some short names and no middle name in one of the file but the other one has full name and short middle name. It can be done with VBA but if your data is not unique then there is no

$$Excel-Macros$$ forgot password

2009-09-23 Thread manish
ive forgot password to the new project macro i have created in VB excel. how to recover that macro password. can someone please tell me the method to find it. regards manish --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Need urgent help on finding formula

2009-09-23 Thread Sandeep Kumar Maurya
Hi VR, Find the attached solution. Regards Sandeep On Tue, Sep 22, 2009 at 8:05 PM, vinod rao vinod.ma...@gmail.com wrote: HI Team, need a foumula to find the latest Date and in next column the Status Plz find attached.file. Thanks in advance. VR

$$Excel-Macros$$ Re: help plz

2009-09-23 Thread Sandeep Kumar Maurya
Hello Ashish, Do you have your data ready or you want to enter the data then a new row below it. Means your data already have parent co in column B are you going to enter it in column B. Regards Sandeep On Wed, Sep 23, 2009 at 10:29 AM, ashish koul koul.ash...@gmail.com wrote: inserting a

$$Excel-Macros$$ Re: Need to color the duplicates

2009-09-23 Thread Harmeet Singh
Hi Sonia, If you open the VBE window, u will see a for each loop, that is changing the cell color for all the selected cells. Let me know if more clarification is required. :) Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Sep 23, 2009 at 1:34 PM, Sonia Singla

$$Excel-Macros$$ Re: forgot password

2009-09-23 Thread Harmeet Singh
can u send that file.. i will try to recover passowrd.. Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Sep 23, 2009 at 8:27 PM, manish manish_karandi...@yahoo.com wrote: ive forgot password to the new project macro i have created in VB excel. how to recover that

$$Excel-Macros$$ Substring across a range of cells

2009-09-23 Thread sjharris27
I have a spreadsheet populated with game score data imported from an external source (so I can't change the format!) that consists of between 2 and 4 cells each containing a name (variable length) and a score (always 3 characters) in the following format; cell#1 cell#2

$$Excel-Macros$$ Complicated nested IF inside cell formula macro

2009-09-23 Thread c
Hi Everyone, I'm having troubles with this formula. It currently works. But I would like to extend the range out to column CE. There are 2 problems: 1). I would like to wrap the text of this formula so that it appears as 4 lines in the vba editor. It's too hard to read as 1 gigantic line.

$$Excel-Macros$$ Re: $$ TIP $$ Backing up Excel Files

2009-09-23 Thread vikas goel
i am also aggree with u guys. On Thu, Sep 17, 2009 at 6:51 PM, Aindril De aind...@gmail.com wrote: Hats Off Ayush... Excellent Tip... Regards, Andy On Thu, Sep 17, 2009 at 7:31 PM, Ayush Jain jain_ayus...@yahoo.comwrote: ** Do you have important Excel files that would create

$$Excel-Macros$$ Re: Help with quotes in COUNTIF formula

2009-09-23 Thread Dave Bonallack
Hi, Try this: Range(C CStr(LCurSRow)).Formula = =COUNTIF(Dept!AR CStr(lRow) :CE CStr(lRow) ,0) Regards = Dave. Date: Wed, 23 Sep 2009 17:12:13 -0700 Subject: $$Excel-Macros$$ Help with quotes in COUNTIF formula From: cad...@gmail.com To: excel-macros@googlegroups.com Hi

$$Excel-Macros$$ Re: Substring across a range of cells

2009-09-23 Thread Dave Bonallack
Hi, If you attach a sample file, I think we can help you. Regards - Dave. Date: Wed, 23 Sep 2009 14:33:11 -0700 Subject: $$Excel-Macros$$ Substring across a range of cells From: sjharri...@btinternet.com To: excel-macros@googlegroups.com I have a spreadsheet populated with game score