$$Excel-Macros$$

Sheets(1).Application.DefaultSheetDirection = -5004 Sheets(1).DisplayRightToLeft = true This number -5004 What is this number mean? And what is the different between that two lines? -- -- Som

Re: $$Excel-Macros$$ Non-Uniform Random Number Generator

Hello! If you have your distribution 1 to 1000 for exemple. So, do =*RANDBETWEEN*(1:1000) Sorry if I posibly understand wrong Best Regards André Luiz D´Avila - Auditor Moore Stephens Audit 2010/10/27 busboy10 > Hi All, > > Trying to do some modeling where I would like Excel to create a random >

RE: $$Excel-Macros$$ How to consolidate the data using macro

Perfect solution sir. Thanks a million. Regards Hiren From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: Thursday, October 28, 2010 8:07 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to consolidate the data using ma

Re: $$Excel-Macros$$ manage lengthy database

Sub applyfilter() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If ActiveSheet.Range("$A$1:$B$27").AutoFilter Field:=2, Criteria1:= _ ">=10/31/2010", Operator:=xlAnd, Criteria2:="<=11/18/2010" End Sub Sub RemoveFilter() If ActiveSheet.AutoFilterMode

Re: $$Excel-Macros$$ How to consolidate the data using macro

try attached file see if it helps . On Thu, Oct 28, 2010 at 3:46 PM, Hiren Sheth wrote: > Hi Excel Gurus, > > > > I would like to prepare the consolidated file on daily basis using macro. I > am using excel 2010. > > > > My team is working daily on some excel files(around 25-50 files). All e

Re: $$Excel-Macros$$ manage lengthy database

Hi Rakesh, You can also change gridline colour or give colours to the cells in which you want to see your Cursor.To change thecoulour of gridline(if you are using excel 2007) Go to the Excel ribbon Button then go to the Excel option Button In that go to that advanced option. In that advanced opt

Re: $$Excel-Macros$$ data cleaning in excel

Hi, You can download an add-in called as"Ultimate add-in" which is available for Excel @007 and for older versions also(Excel 2000.2003,2005 etc). It contains a tool called Duplicate remover. There are also mainy other very useful tool in that add-in which will be very useful to you.But make sure

Re: $$Excel-Macros$$ Excel Date format dd/mm/yyyy hh:mm:ss

Hi, Forst Select your dat then go to format in the Home Menu(if your using Excel 2007) or format if you are using older versions.In the format menus dialog box you can select date formats as you like.At the last the is Customs format. If you select that and specify what ever type of format you w

RE: $$Excel-Macros$$ How to consolidate the data using macro

Hi Excel Gurus, I would like to prepare the consolidated file on daily basis using macro. I am using excel 2010. My team is working daily on some excel files(around 25-50 files). All excel files are save in a particular folder on daily basis with name containing the date stamp. I would like to

Re: $$Excel-Macros$$ Re: Help Required!

I don't understand which linguage do you use? In visual basic as I have proposed is a function you can pass any text and use its result regards r 2010/10/28 amrahs k > Hi, > > This works great. Thanks for your efforts and help. Though I have a small > need as well. > > The code gives the ou

Re: $$Excel-Macros$$ manage lengthy database

hi Ashish Thanks for ur reply, but i am using windows XP,I coukdn't open the file u send.let me know what to do. Regards Rajesh On 10/28/10, ashish koul wrote: > check the attachment for custom filter on dates. in case you are using > background colors . > > > On Wed, Oct 27, 2010 at 10:52 PM, R

RE: $$Excel-Macros$$ Parsing a range to an array

Hi, You can test for a non-contiguous selection with the following line of code: A = Selection.Areas.Count Use this in an If statement - eg If Selection.Areas.Count > 1 then msgbox "You can't use non-contiguous cells.": Exit Sub Hope this helps. Regards - Dave. > Date: Thu, 28 Oct 20

$$Excel-Macros$$ Re: New Member

Welcome Ted, Please feel free to post your queries. Hope we all learn together Warm regards, Anand Kumar On Oct 26, 7:47 pm, Ted wrote: > Hi, just joined the group to take a look at what I could learn.  I'll > be posting any questions I have shortly. -- ---

$$Excel-Macros$$ Parsing a range to an array

Hi Everyone, I am building a series of wizards for handling some internal processes at my office. We are extracting data from from '3rd party' data sources into excel worksheets. To further process this data by hand is slow, so I was asked to write a few macros etc to speed things up. The issue I

Re: $$Excel-Macros$$ data cleaning in excel

Good solution Dililp, The data scenario sure presents the conflict you have mentioned. What can be done to work around it? Warm regards, Anand Kumar anand...@gmail.com On Oct 27, 11:26 am, SAJID MANSOOR wrote: > Good! > > On Sun, Dec 13, 2009 at 6:01 PM, Dilip Pandey wrote: > > Ok,  The soluti