Re: $$Excel-Macros$$ Remove Zero using vba function

2011-11-10 Thread jmothilal
u want to remove entire row i.e a=0 like On Wed, Nov 9, 2011 at 8:08 PM, Abhijit Mitra wrote: > Dear all > Can you help me out how to remove zero from a sheet: > Example: > > A=0 > B=0 > C=0 > D=2 > E=3 > F=56 > G=0 > H=67 > I=9 > J=0 > K=0 > > I just want to remove zero from start and end (A,B,

$$Excel-Macros$$ Remove Zero using vba function

2011-11-09 Thread Abhijit Mitra
Dear all Can you help me out how to remove zero from a sheet: Example: A=0 B=0 C=0 D=2 E=3 F=56 G=0 H=67 I=9 J=0 K=0 I just want to remove zero from start and end (A,B,C,J,K) but should not remove the zero from between number, Please if any one have any idea how to make vba function for this plea