use this function
Function checkformula(x As Range) checkformula = x.HasFormula End Function check the attachment On Sun, Dec 19, 2010 at 1:49 AM, hanumant shinde <arsfan2...@yahoo.co.in>wrote: > hey deepak, > > thanks man but any idea about 1st que? > > > 1. how can i get to know if a specific cell has formula or normal value? > i.e if A1 has value or formula? > > > *From:* Rohan Young <rohan.j...@gmail.com> > > *To:* excel-macros@googlegroups.com > *Sent:* Fri, 17 December, 2010 9:49:55 AM > > *Subject:* Re: $$Excel-Macros$$ Need ans for 3 que > > 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 > > > -- > > ---------------------------------------------------------------------------------- > 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* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- 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
Book1.xlsm
Description: Binary data