Re: $$Excel-Macros$$ If date in One then another cell to be unlock

2012-04-13 Thread ITP Abdulgani Shaikh
Pl.find attached sample file On Sat, Apr 14, 2012 at 12:19 PM, ITP Abdulgani Shaikh < itpabdulg...@gmail.com> wrote: > Dear Freinds, > > Please help me on following issue > > My worksheet is protected, out of all cells, some cells are unprotected > for entering data. > If I am entering data in Ce

$$Excel-Macros$$ If date in One then another cell to be unlock

2012-04-13 Thread ITP Abdulgani Shaikh
Dear Freinds, Please help me on following issue My worksheet is protected, out of all cells, some cells are unprotected for entering data. If I am entering data in Cell C3 then Cell E3 should be auto unlock the cell. and if there is no data in Cell C3 or zero in C3 then Cell E3 should be auto loc

Re: $$Excel-Macros$$ Index function help needed

2012-04-13 Thread dguillett1
Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Mr Excellent Sent: Friday, April 13, 2012 5:22 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Index function help needed Hi All, Need a simple index function with a drop given to auto publish the va

Re: $$Excel-Macros$$ Index function help needed

2012-04-13 Thread Sam Mathai Chacko
Check attached REgards, Sam Mathai Chacko On Sat, Apr 14, 2012 at 3:52 AM, Mr Excellent wrote: > Hi All, > > Need a simple index function with a drop given to auto publish the values > in the given table > > Please help > > Thanks > Excellent > > -- > FORUM RULES (986+ members already BANNED for

$$Excel-Macros$$ Index function help needed

2012-04-13 Thread Mr Excellent
Hi All, Need a simple index function with a drop given to auto publish the values in the given table Please help Thanks Excellent -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formul

RE: $$Excel-Macros$$ Call a Function

2012-04-13 Thread Asa Rossoff
Hi Matt, I am not doing much programming these days, and I don't have a super expert answer for you. .But I imagine there might be some use in a class for each field -- if anything though, I would think the first and most useful step might be to create a class for your database (something akin

RE: $$Excel-Macros$$ Error while inserting raw

2012-04-13 Thread Rajan_Verma
HI Is there any error showing while inserting Row. Like Object can't move , or check your worksheet is protected or not Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: Apr/Fri/2012 05:55 To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Sorting cells

2012-04-13 Thread Rajan_Verma
Hi Why don't you use sort by the way Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of kenrock Sent: Apr/Thu/2012 08:59 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sorting cells I have the word "London" in cell A1, "Paris" i

RE: $$Excel-Macros$$ RepWait

2012-04-13 Thread Rajan_Verma
What is this sajid? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SAJID MEMON Sent: Apr/Fri/2012 03:00 To: abdul_kpar...@hotmail.com Subject: $$Excel-Macros$$ RepWait "Hi,bro! What's up? You know what. Recently I find a really nice website, zol-g

Re: $$Excel-Macros$$ Argh. Previously posted evaluate function replacing loop has unnoticed major error

2012-04-13 Thread Domain Admin
This is the version I am using tmprange.Value2 = .Evaluate("IF(ROW(),round(" & tmprange.Address & ",2))") On Fri, Apr 13, 2012 at 12:42 AM, Asa Rossoff wrote: > Hi Rajan, > I think it's been a series of topics.  I don't think I could summarize them. > Maybe Domain has a thought on what w

Re: $$Excel-Macros$$ How to Delete End (Shift Enter) - Macro Needed

2012-04-13 Thread Sam Mathai Chacko
Try the Word Help forum here http://www.excelfox.com/forum/f5/ Regards, Sam On Fri, Apr 13, 2012 at 6:48 PM, dguillett1 wrote: > This is an excel forum. Pls post excel files. > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Patil MG > *Sent:* Fr

Re: $$Excel-Macros$$ Error while inserting raw

2012-04-13 Thread dguillett1
You may send you file to ME with a complete explanation Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ashish Bhalara Sent: Friday, April 13, 2012 7:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Error while inserting raw Dear expert Please

Re: $$Excel-Macros$$ How to Delete End (Shift Enter) - Macro Needed

2012-04-13 Thread dguillett1
This is an excel forum. Pls post excel files. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Patil MG Sent: Friday, April 13, 2012 1:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to Delete End (Shift Enter) - Macro Needed Hi Kumar / Ra

RE: $$Excel-Macros$$ Argh. Previously posted evaluate function replacing loop has unnoticed major error

2012-04-13 Thread Asa Rossoff
Hi Rajan, I think it's been a series of topics. I don't think I could summarize them. Maybe Domain has a thought on what was most valuable. Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Thursday, April 12,