hey Ashish,
this link is too good man. THANKS A LOT DUDEEEEE. u made my day. awesome stuffs
but can u or somebody help me with below 1 line
Dim FSO As Object
Set FSO = CreateObject("scripting.filesystemobject")
what does this line do.
>
>From: ashish koul <koul.ash...@gmail.com>
>To: excel-macros@googlegroups.com
>Sent: Sat, 18 December, 2010 11:26:12 AM
>Subject: Re: $$Excel-Macros$$ Need ans for 3 que
>
>unzip using vba check out this link
>
>http://www.rondebruin.nl/windowsxpunzip.htm
>
>
>On Sat, Dec 18, 2010 at 2:00 AM, Deepak Rai <daksh1...@gmail.com> wrote:
>
>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
>>
>
>
>--
>
>Regards
>
>Ashish Koul
>akoul.blogspot.com
>akoul.wordpress.com
>My Linkedin Profile
>
>
>PBefore 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
>
--
----------------------------------------------------------------------------------
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
