Re: $$Excel-Macros$$ I need help breaking a numerical data range. I have an excel worksheet with over 6000000 rows of dat

2016-09-06 Thread Paul Schreiner
What is the format of the data source?What are you trying to do with the data?  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever

Re: $$Excel-Macros$$ I need help breaking a numerical data range. I have an excel worksheet with over 6000000 rows of dat

2016-09-06 Thread Learner Excel
If the row count is really 60lac than I strongly suggest you to please use MS-Access for any DB (like MYSql or MSSQL) as Excel have rows limit (10lac only.) -- On Tue, Sep 6, 2016 at 1:24 PM, Malungo Tomson Banda < malungotoms...@gmail.com> wrote: > I need help breaking a numerical data range.

Re: $$Excel-Macros$$ I Need help.. need someone to write up a macro for me...please!! lol

2014-02-08 Thread Ankit Mehra
Hi Joe, In order to do so, an user form needs to be created which will ask for a user name and password. Once the individual specifies the credentials, user will be able to work on this. If you could share the file, this can be done. Thanks, Ankit Mehra On 8 Feb 2014 13:32, "Joe Rainone" wrote:

RE: $$Excel-Macros$$ I need help on one Macro creation

2013-09-25 Thread Ravinder
Give us more information..for this. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sandes Bagwe Sent: Tuesday, September 24, 2013 8:56 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ I need help on one Macro creation Hello All, I h

Re: $$Excel-Macros$$ I need help with making a macro relative to a selection field within the macro

2013-08-30 Thread De Premor
Try to using Offset Ex: Before you run your code, active / selected cell was on C3, then try to run this code Sub Tes() ActiveCell.Offset(1,0).Select'Move 1 Cell Down Stop'See Your Current Selected Cell Now, then back here and press F8 ActiveCell.Offset(0,1).Select'Mov

Re: $$Excel-Macros$$ I need help with making a macro relative to a selection field within the macro

2013-08-30 Thread De Premor
sorry, On Red Bold i mean ActiveCell.Offset(1,1) On 31-08-2013 0:56, De Premor wrote: Try to using Offset Ex: Before you run your code, active / selected cell was on C3, then try to run this code Sub Tes() ActiveCell.Offset(1,0).Select'Move 1 Cell Down Stop'See Your Current Se

Re: $$Excel-Macros$$ I need help

2011-10-06 Thread Ahmed Emam
Thanks very much for your help, that's exactly what i need. Thanks again On Thu, Oct 6, 2011 at 3:56 AM, ChilExcel wrote: > Please see attachment > > Chilexcel > > > 2011/10/4 Ahmed Emam > >> Hi all members, >> >> I need an Excel sheet that contains check list for about 20 items , and >> that w

Re: $$Excel-Macros$$ I need help

2011-10-05 Thread rajan verma
Hi, Do You want something Like this : Sub MakeComponentinRunTImeOnSpreadSheet() On Error Resume Next Dim cb As OLEObject n = 5 For i = 1 To 10 Set cb = ActiveSheet.OLEObjects.Add(classtype:="Forms.Checkbox.1") With cb .Top = n .Object.Caption

Re: $$Excel-Macros$$ I need help

2011-10-04 Thread Ahmed Emam
tober 04, 2011 1:16 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ I need help > > Here it's attached > > On Tue, Oct 4, 2011 at 8:39 PM, NOORAIN ANSARI > wrote: > >> Dear Ahmed, >> >> if possible, Can you share Sample shee

Re: $$Excel-Macros$$ I need help

2011-10-04 Thread dguillett1
Can you simply use data>validation as shown in the attached From: Ahmed Emam Sent: Tuesday, October 04, 2011 1:16 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ I need help Here it's attached On Tue, Oct 4, 2011 at 8:39 PM, NOORAIN ANSARI wrote: Dear Ahme

Re: $$Excel-Macros$$ I need help

2011-10-04 Thread Ahmed Emam
Here it's attached On Tue, Oct 4, 2011 at 8:39 PM, NOORAIN ANSARI wrote: > Dear Ahmed, > > if possible, Can you share Sample sheet with group.. > > On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam wrote: > >> Hi all members, >> >> I need an Excel sheet that contains check list for about 20 items

Re: $$Excel-Macros$$ I need help

2011-10-04 Thread NOORAIN ANSARI
Dear Ahmed, if possible, Can you share Sample sheet with group.. On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam wrote: > Hi all members, > > I need an Excel sheet that contains check list for about 20 items , and > that will be as a to-do note. > Can anyone help me? > > Thanks in advance > > -

Re: $$Excel-Macros$$ I need help

2011-10-04 Thread Ahmed Emam
the file i need will have a list and every item will has in the next column a check box that when i finish with one item i can check it. As i told before it will be a to-do list. Thanks On Tue, Oct 4, 2011 at 7:18 PM, rajan verma wrote: > hi, > please explain .. > > On Tue, Oct 4, 2011 at 11:38 A

Re: $$Excel-Macros$$ I need help

2011-10-04 Thread rajan verma
hi, please explain .. On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam wrote: > Hi all members, > > I need an Excel sheet that contains check list for about 20 items , and > that will be as a to-do note. > Can anyone help me? > > Thanks in advance > > -- > > ===* > * >