Hi Rohan, This is really nice.
Regards, Deepak Rai On Fri, Dec 17, 2010 at 9:49 AM, Rohan Young <rohan.j...@gmail.com> wrote: > Hi Hanumant, > > Just hit Ctrl+F go to option and in look in set the criteria on Values u > will get that > > bye for now > > Deepak (ROHAN) > 9818247278 > > > On Thu, Dec 16, 2010 at 3:45 PM, hanumant shinde > <arsfan2...@yahoo.co.in>wrote: > >> hey guys, >> >> need some help here. >> >> 1. how can i get to know if a specific cell has formula or normal value? >> >> 2. can we unzip folder or file using excel maco? >> >> 3. if a specific cell has formula whose value is lets say "shinde" how can >> i >> find it. >> >> i.e lets say A1 has value as "shinde"(its not fomula its normal string) >> B1=A1 (its a formula) >> now i want to find shinde in col B but its formula so i cant find it even >> by >> Ctrl + F >> so what shud b the code to find "shinde" in col B. >> >> thanks >> hanumant >> >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > -- > > ---------------------------------------------------------------------------------- > 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.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Regards, Deepak Rai -- ---------------------------------------------------------------------------------- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
