OT Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-21 Thread Paul Schreiner
__ From: hanumant shinde To: excel-macros@googlegroups.com; koul.ash...@gmail.com Cc: excel-macros@googlegroups.com Sent: Mon, December 20, 2010 3:27:52 PM Subject: Re: $$Excel-Macros$$ Need ans for 3 que hey ashish you have any idea about below 1 line code. can you or someb

Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-20 Thread hanumant shinde
groups.com Sent: Sun, 19 December, 2010 2:06:46 AM Subject: Re: $$Excel-Macros$$ Need ans for 3 que hey Ashish, this link is too good man. THANKS A LOT DUDE. 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.f

Re: Fwd: $$Excel-Macros$$ Need ans for 3 que

2010-12-20 Thread hanumant shinde
thanks kantilal From: Kantilal Badale To: excel-macros Sent: Mon, 20 December, 2010 10:35:12 PM Subject: Fwd: $$Excel-Macros$$ Need ans for 3 que Use conditional formatting to highlight cell containing formula Kantilal -- Forwarded

Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-20 Thread hanumant shinde
hey thanks Ashish, that was really very simple yar. :) From: ashish koul To: excel-macros@googlegroups.com Sent: Sun, 19 December, 2010 11:52:44 AM Subject: Re: $$Excel-Macros$$ Need ans for 3 que use this function Function checkformula(x As Range

Fwd: $$Excel-Macros$$ Need ans for 3 que

2010-12-20 Thread Kantilal Badale
Use conditional formatting to highlight cell containing formula Kantilal -- Forwarded message -- From: ashish koul Date: Sun, Dec 19, 2010 at 11:52 AM Subject: Re: $$Excel-Macros$$ Need ans for 3 que To: excel-macros@googlegroups.com use this function Function

Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-18 Thread ashish koul
ell has formula or normal value? > i.e if A1 has value or formula? > > > *From:* Rohan Young > > *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 h

Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-18 Thread hanumant shinde
os@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 wrote: > >Hi Rohan

Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-18 Thread hanumant shinde
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 >To: excel-macros@googlegroups.com >Sent: Fri, 17 December, 2010 9:49:55 AM >Subject: Re: $$Excel-Ma

Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-17 Thread ashish koul
unzip using vba check out this link http://www.rondebruin.nl/windowsxpunzip.htm On Sat, Dec 18, 2010 at 2:00 AM, Deepak Rai wrote: > Hi Rohan, > > This is really nice. > > Regards, > Deepak Rai > > On Fri, Dec 17, 2010 at 9:49 AM, Rohan Young wrote: > >> Hi Hanumant, >> >> Just hit Ctrl+F go t

Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-17 Thread Deepak Rai
Hi Rohan, This is really nice. Regards, Deepak Rai On Fri, Dec 17, 2010 at 9:49 AM, Rohan Young 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

Re: $$Excel-Macros$$ Need ans for 3 que

2010-12-17 Thread Rohan Young
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 wrote: > hey guys, > > need some help here. > > 1. how can i get to know if a specific cell has formula or

$$Excel-Macros$$ Need ans for 3 que

2010-12-16 Thread hanumant shinde
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