Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-18 Thread ponnusamy paramasivan
On 7/4/12, NOORAIN ANSARI wrote: > Dear Mangesh, > > Please put it in Module after press Alt+F11. > Then we can use it under Activeworkbook. > > > On Wed, Jul 4, 2012 at 8:06 PM, Mangesh Vimay > wrote: > >> Thanks Noorain Where should I put this code. I mean in module or any >> the place to run th

Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread NOORAIN ANSARI
Dear Mangesh, Please put it in Module after press Alt+F11. Then we can use it under Activeworkbook. On Wed, Jul 4, 2012 at 8:06 PM, Mangesh Vimay wrote: > Thanks Noorain Where should I put this code. I mean in module or any > the place to run the code. > Please tell me detail as u know very wel

Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread Mangesh Vimay
Thanks Noorain Where should I put this code. I mean in module or any the place to run the code. Please tell me detail as u know very well I am new to VBA. On 7/4/12, NOORAIN ANSARI wrote: > Dear Mangesh, > > Please use it > > *Function Test(rng As Excel.Range) > If rng.Value <> "" And rng.Value <

Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread NOORAIN ANSARI
Dear Mangesh, Please use it *Function Test(rng As Excel.Range) If rng.Value <> "" And rng.Value <= 24 Then Test = "<24 Hours" ElseIf rng.Value <> "" And rng.Value > 24 Then Test = ">24 Hours" Else Test = "" End If End Function * On Wed, Jul 4, 2012 at 7:52 PM, Mangesh Vimay wrote: > Hi Friends/

Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread Mangesh Vimay
Hi Friends/Ashish, How will you put this formula in vba code. please tell. On 7/4/12, Mangesh Vimay wrote: > Thank you so much mere bhai u saved my job > > On 7/4/12, ashish koul wrote: >> = iF(ISBLANK(A2),"",IF(A2<=24,"<24 Hours",">24 Hours")) >> >> >> >> On Wed, Jul 4, 2012 at 7:35 PM, M

Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread Mangesh Vimay
Thank you so much mere bhai u saved my job On 7/4/12, ashish koul wrote: > = iF(ISBLANK(A2),"",IF(A2<=24,"<24 Hours",">24 Hours")) > > > > On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay > wrote: > >> Hi Friends, >> >> Please find the attached sheet for if statement. >> Please help me dear all

Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread ashish koul
= iF(ISBLANK(A2),"",IF(A2<=24,"<24 Hours",">24 Hours")) On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay wrote: > Hi Friends, > > Please find the attached sheet for if statement. > Please help me dear all !!! > > -- > With regards, > > MaNgEsH > > -- > FORUM RULES (986+ members already BANNED for

$$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread Mangesh Vimay
Hi Friends, Please find the attached sheet for if statement. Please help me dear all !!! -- With regards, MaNgEsH -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code