$$Excel-Macros$$ Making sheet references dynamic

2010-07-26 Thread Edgar
can't figure it out. -Edgar -- -- 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 @ http://www.linkedi

Re: $$Excel-Macros$$ how do you identify the first space within a series of words within a a text

2010-07-23 Thread Edgar Ejercito
Thanks, Sandeep. I really appreciate it. Edgar On Wed, Jul 21, 2010 at 10:15 PM, Sandeep Kumar Maurya < sandymau...@gmail.com> wrote: > Hi Edgar, > > Function you are applying is correct. So please attached your file so > that problem can be solved. > > Thanks &

$$Excel-Macros$$ Re: how do you identify the first space within a series of words within a a text

2010-07-22 Thread Edgar
Thanks, everyone. What a JV mistake. :) On Jul 21, 9:24 pm, "Soni.Rajender" wrote: > Hi > > You can use the formulaes as below: > > = FIND(" ",A1,1)                          or > =SEARCH(" ",A1,1) > > Regards > Rajender Soni ! 750 322

$$Excel-Macros$$ how do you identify the first space within a series of words within a a text

2010-07-21 Thread Edgar
I'm trying to clean up some data. I've used SEARCH and FIND to try to identify the first space within a cell, but the answer comes back incorrect. I've used SEARCH("", Cell Reference) It's giving me the first cell. For example, the answer to this would be 1. If I used SEARCH("", Cell reference,

$$Excel-Macros$$ IF statement logic

2010-01-28 Thread capt edgar
Hi there I have attached a simple spreadsheet with a table in it All the cells except the headers in the tables are conditional formatted so that if i select a cell in the table as No, the colour of the cell turns red if i select Yes, the cell color turns green and if i select NA, the cell color t

$$Excel-Macros$$ Dependent Lists

2010-01-11 Thread capt edgar
Hi there I have attached a small excel sheet called TESTTHEM which i'm testing and learning excel simultaneously. On the attached sheet under the type column, i have created a dropdown list with some values in it. If i select a value from the dropdown list say for ex: Pictures, is it possible to

$$Excel-Macros$$ Event Difference

2010-01-06 Thread capt edgar
Hi there Can u please tell me what is the difference between worksheet_change and worksheetselection_change events please? I can't find a proper definition for it on google anywhere. Also can u tell me a good place for code snippets for vba for quick use in vba programming regards -- -