$$Excel-Macros$$ Re: Find the Number

2009-09-06 Thread jonell
ached sheet. > > -- > With Love, > Mahesh Bisht > > Book1.xlsx > 15KViewDownload Hi Mahesh, I hope the attached file will help. Regards, Jonell --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Calculating renewal dates

2009-09-06 Thread jonell
010 > 7/28/2004 7/28/2010 > 8/2/20028/2/2010 > 8/10/2006 8/10/2010 > > Any ideas or suggestions would be greatly appreciated. > > -Eric Hi Eric, My suggestion is to create a column in

$$Excel-Macros$$ Re: Macro for copying all data

2009-09-04 Thread Jonell
com/en-us/library/cc837974.aspx Regards,Jonell --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at htt

$$Excel-Macros$$ Re: Help for Compile Error : End if without block if

2009-09-04 Thread Jonell
End If 'add this line or move from above "Next Cell" cleanup: Set OutApp = Nothing With Application .EnableEvents = True .ScreenUpdating = True End With End Sub Regards, Jonell --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Re:Site formulation inclusing Multiple freq.

2009-09-03 Thread jonell
each site will vary, the formulas will need to be changed to allow for that. (click on the menu Format-Conditional Formatting...) Hope this will help you. Regards, Jonell --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re:ROUNDUP

2009-08-25 Thread jonell
> +33665248617 Hi Nourredine, A solution is attached which can use either the RoundUp or RoundDown functions and covers the range from1 to 99.9 million. You can change the formula to use it for numbers less than 1m as demonstrated. Hope

$$Excel-Macros$$ Re: Dynamic Menu Creation - EVent bassd

2009-08-23 Thread Jonell
b Worksheet_Deactivate() 'To unhide Application.CommandBars("Your custom menu Name").Enabled = True End Sub Regards, Jonell On Aug 22, 1:33 am, kamal shah wrote: > Hi Team, > > I wrote piece of code to generate Dropdown Menu and call various Macros from > it. > Thi

$$Excel-Macros$$ Re: Need to track minutes

2009-08-18 Thread jonell
> Thanks. > Hi Sachin, Here's a solution with difference shown in minutes as requested. Regards, Jonell --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel

$$Excel-Macros$$ Fwd: about to remove "#VALUE!" error

2009-08-16 Thread jonell
al formatting! Please refer to attachedfile for explanation. Regards, Jonell --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),

$$Excel-Macros$$ Please Help Me!!!

2009-08-13 Thread jonell
oaded" marks values and I have put some comments in red text for your consideration. Hope this helps. Regards, Jonell --~--~-~--~~~---~--~~ -- Some important links for excel user

$$Excel-Macros$$ Re: counting of diffrent cell values of same name or Numbers in nos

2009-08-05 Thread jonell
On Aug 4, 10:44 pm, shivashankar katageri wrote: > Dear all, > > any body help me to sort out the with attached sheet > -- > Thanks & Regards > > Shivashankar.C.Katageri. Hi Shivashankar, Here's another solution using VBA that may interest you. Hope you find

$$Excel-Macros$$ Re: Auto Filter - Custom Auto Filter

2009-08-02 Thread jonell
y5, The attached file may be what you're looking for. Explanations of how it works is in the file. Hope it helps. Regards, Jonell --~--~-~--~~~---~--~~ -- Some important links fo