$$Excel-Macros$$ Legal Notice/Splash Screen

2010-06-13 Thread Michael Hayes
Good Afternoon to all, I'm developing a spreadsheet to calculate insurance rates for a large client. Within the spreadsheet are some highly proprietary algorithms that I developed that describe the relationships between costs and "richness" of benefits.My client believes this spreadsheet/program w

Re: $$Excel-Macros$$

2010-06-13 Thread Deepak Pal Singh
Thanks Dave & Mahesh, I solved my query with the help of you..:-) On Sun, Jun 13, 2010 at 10:19 AM, Mahesh parab wrote: > Hi Deepak > > Try > Sub FindCell() > Dim FirstCell As String > Dim i As Integer > FirstCell = "A1" > Range(FirstCell).Select > Do Until ActiveCell.Value = "" > If ActiveCell.

$$Excel-Macros$$ Re: vba programming

2010-06-13 Thread Harpreet Singh Gujral
Hi Airen, Would you be able to explain the following, so that the group can help you out: 1) Is there a criteria, you want to use, on the table on Sheet1. Because this criteria, will be embeded in the check box...or please tell us, what do you want to achieve with the checkbox, that you have

Re: $$Excel-Macros$$ Automatically insert name

2010-06-13 Thread sudhi na
Dear Vikas, Here is one file Which I hope will solve your problem Click on the button and the names will be listed in their respective numbers.you can see the macro in the visual basic editor regards -Sudheer On Sat, Jun 12, 2010 at 8:44 PM, Vikas Chouhan wrote: > Dear Group Member(s),

$$Excel-Macros$$ vba programming

2010-06-13 Thread airen
hi all, i've a table in sheet1,now i want to select some rows using check box and then using commmand buttons i've to either move these rows in a table of sheet2 or alter these rows in sheet1 only. Thanx Airen -- --