Re: $$Excel-Macros$$ how many count zero of 10000000 with excel formula

2014-05-20 Thread Vishal Angre
=LEN(K4)-LEN(SUBSTITUTE(K4,"0","")) On Wed, May 21, 2014 at 10:19 AM, Ashish Kumar wrote: > Hi Saleem, > > PFA!!! > > > Thanks > Ashish > > > -- Forwarded message -- > From: Saleem Ansari > ​​ > < > ​​ > saleem.logic...@gmail.com> > Date: 21 May 2014 10:09 > Subject: Re: [XL-

Re: $$Excel-Macros$$ Need Help

2012-07-10 Thread vishal angre
On Tue, Jul 10, 2012 at 3:55 PM, Deba Ranjan wrote: > PFA, might it will help you. > > > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Tue, Jul 10, 2012 at 3:35 PM, Imran khan wrote: > >> Hello, >> >> I need IF formula in attached sheet. IF Column C>0, Then Pre-Ops >> otherwise C

Re: $$Excel-Macros$$ need a macro to change the background color a cell as soon as i change the value (alphanumeric)

2012-07-04 Thread vishal angre
see attached file On Wed, Jul 4, 2012 at 11:53 AM, vijay yadav wrote: > Hi, > > how to conditional format for a changed alpahnumerical cell value? is it > possible? > > if i have a filled worksheet where > > tb3 is value in cell A1 and > > *tb4 is value in cell A2* > and > > I change cell *A1

Re: $$Excel-Macros$$ delete blank columns

2012-06-18 Thread vishal angre
press F5 > click special button > select blanks button selected cell delete On Fri, Jun 15, 2012 at 11:56 AM, Excel Vba wrote: > Hi Smitha, > > PFA Workbook. I hope this will help u. > > Regards, > Hemant. > > > > --

Re: $$Excel-Macros$$ Vlookup in Macro

2010-12-11 Thread Vishal Angre
Sub vlookup() Dim lookfor As Range Dim rng As Range Dim col As Integer Set lookfor = ActiveCell.Offset(0, -1) Set rng = ActiveWorkbook.Worksheets("MV").Range("A:C") col = 3 dept_code = Application.WorksheetFunction.vlookup(lookfor, rng, col, 0) End Sub On Fri, Dec 10, 2010 at 10:02

Re: $$Excel-Macros$$ Excel Utilities

2010-11-13 Thread Vishal Angre
JMT EXCEL UTILITIES http://www.andrewsexceltips.net/JMT%20Full%20List.htm -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Excel Utilities

2010-11-13 Thread Vishal Angre
use this addin for all excel version http://www.asap-utilities.com/download-asap-utilities.php for user help User Guide will show you what you can do with ASAP Utilities http://www2.asap-utilities.com/download/f/ASAP_Utilities_User_Guide.pdf Thanking You Vishal K. Angre --

Re: $$Excel-Macros$$ Macro Help

2010-10-14 Thread Vishal Angre
*code is Thisworkbook in VBAproject * On Wed, Oct 13, 2010 at 6:05 PM, Dharmesh Shah wrote: > Thanks Vishal > > Its working > > Can u explain how u done this (If its posible) > > Once Again Thanks > > Dharmesh Shah > > > > > > On Wed, Oct 13, 2010

Re: $$Excel-Macros$$ Column hide from excel

2010-10-08 Thread Vishal Angre
Thank you On Fri, Oct 8, 2010 at 6:07 PM, عمر wrote: > See this > > http://www.youtube.com/watch?v=CrX6353lSx4 > > > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Vishal Angre > *Sent:* Friday, Octobe

Re: $$Excel-Macros$$ Column hide from excel

2010-10-08 Thread Vishal Angre
ut One Bug :-modify data any time change your log > > sugg :- please enter option on entry then enter protect row > > > Thanks 7 Regards > > Sumit > > > > > On Fri, Oct 8, 2010 at 4:03 PM, Vishal Angre wrote: > >> >> >> 4

$$Excel-Macros$$ Column hide from excel

2010-10-08 Thread Vishal Angre
4 column(A,B,C,D) in atteched excel, please tell me how to do this -- With Regards, *Vishal K. Angre* E-mail : visha...@gmail.com vishal.k.an...@gmail.com -- -- Some important links for excel users: 1.