Re: $$Excel-Macros$$ worksheet change event problem

2010-04-26 Thread OSA
Thank you Dave, The code you suggested worked fine. Although i discovered that the user can still open the file with macro disabled and change the cell content, save and reopen it. now I wish when the workbook is open, it checks the value of sheet1(D3) if equal to "BRIDGESTONE COMPANY INC." if ye

Re: $$Excel-Macros$$ schreiner_p...@att.net; swapnilp1...@gmail.com

2010-04-26 Thread Swapnil Palande
Hi Sundarvelan, Can you send a sample excel, so that we can give you perfect solution. Regards, Swapnil. On Mon, Apr 26, 2010 at 12:47 PM, Sundarvelan N wrote: > Hi Friends, > > I need a help to delete the entire row if a single/particular column > contain a word "B" as the starting letter (S

$$Excel-Macros$$ please help me for Excel Conditional formula with example

2010-04-26 Thread Vikas Chouhan
Dear All, Please help me for excel condition formula's, pls send formula with example ...pls it's a urgent. One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_

Re: $$Excel-Macros$$ Finding cell address of a formula referred to in a cell

2010-04-26 Thread Harpreet Singh Gujral
Thank you all for the solutions provided. Would it possible to locate the cell that has been used in the formula and highlight that cell? Eg: =Sum(A4,a7,a9), when we run the macro, A4,A7,A9 should get highlighted Harry On Apr 26, 10:28 am, rf1234 rf1234 wrote: > Hello Dear, > Attached Workbook

$$Excel-Macros$$ Excel Macro : Help me please

2010-04-26 Thread Sundarvelan
Hello Friends, Any one please correct the error Dim fcount As Range With ActiveSheet Set fcount = Worksheets("N136D").Cells.Find(what:="COUNT", MatchCase:=False).Select Range(Chr((ActiveCell.Column) + 64) & ":" & Chr((ActiveCell.Column) + 64)).Select Selection.Delete On Er

RE: $$Excel-Macros$$ worksheet change event problem

2010-04-26 Thread Dave Bonallack
Hi, Try this code instead: Private Sub Worksheet_Change(ByVal Target As Excel.Range) On Error Resume Next If Sheets("Sheet1").Range("D3") <> "BRIDGESTONE COMPANY INC." Then MsgBox " FILE WILL BE CLOSED!!", vbOKOnly + vbExclamation MsgBox "Please contact EDP " T

$$Excel-Macros$$ Loop and extract part of the data

2010-04-26 Thread Cecilia Chiderski
Resending since I forgot the subject... sorry! Hi, I need some help. I have a long list of customers, and I need to loop through it and extract part of the data. I can not use PivotTables, I need VBA on this. Please find attached a sample model of input/output. This should not be too com

$$Excel-Macros$$

2010-04-26 Thread Cecilia Chiderski
Hi, I need some help. I have a long list of customers, and I need to loop through it and extract part of the data. I can not use PivotTables, I need VBA on this. Please find attached a sample model of input/output. This should not be too complex but I am not very familiar with arrays and loops.

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

2010-04-26 Thread sravani loly
Hi Sudhir,   Try this,,, hope u r talking abut grouping and ungrouping       Rows("1:2").Select     Selection.Rows.Group --- On Sat, 24/4/10, sudhir wrote: From: sudhir Subject: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel To: "MS EXCEL AND VBA M

$$Excel-Macros$$ How to compare two Excel sheets

2010-04-26 Thread sudhir
Dear friends, I have two excel sheets, both are having same format, and contain huge amount of data. now i want to compare them, old one with the new one. and i want to find out which data is deleted, which one is added, and which one is changed. plz help me. -- --

Re: $$Excel-Macros$$ Extracting numbers from a string

2010-04-26 Thread Vikas Chouhan
hi, thanx dear On Mon, Apr 26, 2010 at 10:56 AM, Ahmedhonest wrote: > Dear Team, > > Felt happy to see with your suggestions and thanks a lot i got what i was > looking for. > > A Special one is to *Mr. Vikas Chauhan *appreciate you help and support > the formula was great it solved exactly what

$$Excel-Macros$$ Re: Need help to complete a Excel Model.. Options

2010-04-26 Thread Harpreet Singh Gujral
Vinu, I think the following statement may work for you *ActiveWorkbook.SaveAs Filename:="PAth of the file", _ FileFormat:=xlNormal, Password:="A", WriteResPassword:="A", _ ReadOnlyRecommended:=False, CreateBackup:=False * Group: Guys i think i am not pretty sure about this code, a

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

2010-04-26 Thread sudhir kumar
hi harpreet ji , thank u very much , thats the thing i want -- Regards- Sudhir Kumar Design Engineer, Conceptia Software Technologies Pvt. Ltd. Email id-sudhir.p...@gmail.com, -- -- Some important links for exce

Re: $$Excel-Macros$$ $$Excel - Macros$$ - Need to Break the password of my VBA Code

2010-04-26 Thread rf1234 rf1234
Hello Dear, Please send mail with proper subject line and message.Here We are unable to understand your problem. we can help better when we know your problem. On Mon, Apr 26, 2010 at 10:44 AM, ram kumar.m wrote: > > > -- > Thanks and Regard > ramkumar.m > HAVE A NICE DAY FRNDS:) > > -- >

$$Excel-Macros$$ Macro required for Auto fill

2010-04-26 Thread Rupin Goel
Hello Group, I need a macro to fill the data in the attached sheet. What I want is to fill the vacant cells below cell A4 with the value present in cell A4 till the next valued cell . i.e. as per the attached sheet, I want the value in A4 to be copied till cell A15, then the value in A16 to be

$$Excel-Macros$$ worksheet change event problem

2010-04-26 Thread OSA
Dear group, i try to catch the user's action via worksheet change event. My worksheet has a value at cell D6 that i would like to remain constant and if that value is change by user the workbook is closed. My problem now is, even if this values are unchanged but if any other range of cell is del

Re: $$Excel-Macros$$ Identify unique dates for employee

2010-04-26 Thread Chetan
Hi Harmeet Singh, Thanks for your reply, It works for Month criteria, But i want it for Days criteria , for example if i have 3 entries fro 2nd Jan it shoudl consider as 1, for 3rd jan 2 entries then it should consider it as 1, So total 2 main entries for Jan. Hope i am clear in explaning the pro

Re: $$Excel-Macros$$ Excel-Macro : Help

2010-04-26 Thread OSA
Hello Sundarvelan, I suggest you try first the subtotal function of excel. On the menu click on data then sub total, follow as prompted. It should give you what you need. On Sun, Apr 25, 2010 at 7:49 PM, Sundarvelan N wrote: > Hi Friends, > > I need a macro to sort the below excel by client a

$$Excel-Macros$$ schreiner_p...@att.net; swapnilp1...@gmail.com

2010-04-26 Thread Sundarvelan N
Hi Friends, I need a help to delete the entire row if a single/particular column contain a word "B" as the starting letter (ST-CD is the header of that column). Using VBA Code. Thanks, N.Sundarvelan -- -- Some impor

Re: $$Excel-Macros$$ Extracting numbers from a string

2010-04-26 Thread Ahmedhonest
Dear Team, Felt happy to see with your suggestions and thanks a lot i got what i was looking for. A Special one is to *Mr. Vikas Chauhan *appreciate you help and support the formula was great it solved exactly what i was looking for, once again thanks to all who suggested me. Regards Ahmed Bawaz

$$Excel-Macros$$ How to delete entire row of a column

2010-04-26 Thread Sundarvelan N
Hi Friends, I need a help to delete the entire row if a single/particular column contain a word *"B"* as the starting letter (ST-CD is the header of that column). Using VBA Code. Thanks, N.Sundarvelan -- -- Some imp

$$Excel-Macros$$ $$Excel - Macros$$ - Need to Break the password of my VBA Code

2010-04-26 Thread ram kumar.m
-- Thanks and Regard ramkumar.m HAVE A NICE DAY FRNDS:) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ h

$$Excel-Macros$$ Filling in cells from cell above

2010-04-26 Thread Steve
I have spreadsheets of imported data from another program, so I have no control over the initial formatting of the data. The program puts out data but does not fill in every cell if it is the same data as the cell above it. I am sorting the data several different ways, and having blank cells is t

Re: $$Excel-Macros$$ Excel Groups : date from last Sunday To Saturday

2010-04-26 Thread siti Vi
updating my previous code Sub ListOfWorkWeekDate() Dim dtLastSunday As Date Dim i As Byte dtLastSunday = Date - Weekday(Date) + 1 For i = 1 To 6 ActiveCell(i, 1).NumberFormat = ", dd mmm " ActiveCell(i, 1) = dtLastSunday + i Next End Sub On Apr 23, 3:38 pm, S

Re: $$Excel-Macros$$ Excel Groups : date from last Sunday To Saturday

2010-04-26 Thread siti Vi
The below procedure will create a list of current Work-Week-Date in one-ColumnRange (6 cells) starting at the active cell Sub ListOfWorkWeekDate() Dim dtLastSunday As Date Dim i As Byte dtLastSunday = Date - Weekday(Date) + 1 For i = 1 To 6 ActiveCell(i, 1) = dtLastSunday + i

Re: $$Excel-Macros$$ SAS

2010-04-26 Thread rf1234 rf1234
Hello Dear, Following Is The Discription About Sas SAS Computing •SAS (software), an integrated software suite produced by SAS Institute Inc. •Secure Attention Sequence or secure attention key, a method to invoke a computer operating system's attention, usually signaling it to show the log on scre

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 20 Messages in 12 Topics

2010-04-26 Thread rf1234 rf1234
Hello Dear, Please let us know,which trading software you are using. We can help better,when we understand your problem. On Sat, Apr 24, 2010 at 10:16 PM, nitz gupta wrote: > Dear Friends, > > is there a way with which i can convert my excel file to interact with my > trading software