Re: $$Excel-Macros$$ What is the future of VBA?

It's not easy to say, what with all the changes in that side of the world, but we have to agree that computation in a spreadsheet will remain as long as industries and scenarios need analysis and data interpretation. So I am assuming Excel will be one of the leading spreadsheet application. If VBA

Re: $$Excel-Macros$$ payback Period Formula / Macro

Hi Sharad Use the following function in a general module. Then use =Payback(range) See attached '= Function PayBack(ByRef rng As Range) As Variant 'check that the range has only one dimension If rng.Rows.Count > 1 And rng.Columns.Count > 1 Then Pa

Re: $$Excel-Macros$$ BullsEye Chart

Thanks Raj Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: "Rajan_Verma" Sender: excel-macros@googlegroups.com Date: Sat, 11 Aug 2012 16:49:30 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ BullsEye Chart Hi Group, Just sharing

Re: $$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button

This looks like school homework to me. If we do your homework for you, you learn nothing. Use the resource materials you have no doubt been given, read the book. Try to do it yourself - even if you can only do part of it. Than come back to the group to help you with any specific aspect that is

$$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button

Brothers please help me Thanks N.Sundarvelan 9600160150 -- Forwarded message -- From: Sundarvelan N Date: Wed, Aug 8, 2012 at 2:32 PM Subject: Data Entry - Need insert rows when i press enter button To: excel-macros@googlegroups.com Hello Friends, I need to complete a proje

RE: $$Excel-Macros$$ FW: Excel Formula challenge [Solved]

Well said Paul, But I think Objective of group discussion on any tool (Excel here) is not just helping peoples to complete their project it's also to make them expert so that they can use Excel more smartly . so the challenges gives them opportunity to improve their skills and to understa

Re: $$Excel-Macros$$ Run a Macro in a give time

Paul, Thank you for the explanations. I think now I'm on right way to solve the problem. Cheers!! Regards, Dilan On Wed, Aug 8, 2012 at 3:30 PM, Paul Schreiner wrote: > I may not be 100% accurate with this, because programming capabilities > change, but... > > VBA is written WITHIN Applications.