$$Excel-Macros$$ Re: how to use colour index if the sheet have backgroud color

Hi Rajesh, Refer --> http://msdn.microsoft.com/en-us/library/aa206146(office.11).aspx ColorIndex - Returns or sets the color of the border. The color is specified as an index value into the current color palette, or as a XlColorIndex constant. This property specifies a color as an index into the w

Re: $$Excel-Macros$$ workbook open password protected.

send file On Wed, Nov 17, 2010 at 4:20 AM, Johnnyboy5 wrote: > workbook open password protected. > > I need to be able to get a message box to appear with some > information - before the Password message box appears. I can get the > message to > appear after the Password box - but not before. >

$$Excel-Macros$$ Calculating direction of change across several cells

I'm trying to return a value (1,2,or3) based on the percent change in values since a max value. For example, assume cells A1:E1 contain these values: 200,300,200,50,150. The values represent the number of widgets produced in year 1, year 2, up to year 5. The max value for this example is 300. T

$$Excel-Macros$$ workbook open password protected.

workbook open password protected. I need to be able to get a message box to appear with some information - before the Password message box appears. I can get the message to appear after the Password box - but not before. any ideas. Johnnyboy -- --

Re: $$Excel-Macros$$ AutoSaveAs

Thanks ever so much for your help Paul. On Nov 16, 1:12 pm, Paul Schreiner wrote: -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2.

$$Excel-Macros$$ how to use colour index if the sheet have backgroud color

Hi Experts, Is it possible to use colour index code if i am using a background color on the sheet,pls find the attatchment and find a solution. Thanks in advance Regards Rajesh kainikkara -- -- Some important links

$$Excel-Macros$$ Re: VBA Copying range of cells from one workbook to another while retaining the formulae

Many thanks. I had actually tried that and it had failed but I've subsequently worked out what was going wrong. The worksheet I was copying from was protected. I just needed to unprotect first and it all works fine now. On Nov 16, 1:45 pm, Ashish Jain wrote: > Hi Mike, > > Try this: > RR.Range

$$Excel-Macros$$ Re: VBA Copying range of cells from one workbook to another while retaining the formulae

Hi Mike, Try this: RR.Range("A" & LastRow_RR + 1 & ":CN" & LastRow_RR + LastRow_NWR - 5).Formula = NWR.Range("A6:CN" & LastRow_NWR).Formula Thanks & Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microso

$$Excel-Macros$$ Salary sending problem

Hello Sir, I have a problem related to mail through excel. basically I have to make salary slip. and forward it to the employees. I manage the data into the excel and use mail merge in MS word. now the problem is, I have to make separate file for each employee and have to send one by one on their

$$Excel-Macros$$ VBA Copying range of cells from one workbook to another while retaining the formulae

I have a macro that copies a large range of cells that contains a mixture of cells with values and text and other cells with formulae. I want to copy this range into a new workbook using VBA but I can't seem to retain the formulae (which are converted to their values). I'm sure there is a simple s

Re: $$Excel-Macros$$ AutoSaveAs

You can create a BeforeClose event in which you save the file before exiting. To do it yourself, first, record a macro in which you do a SaveAS (specify file) Then, in the VBA editor, choose the Thisworkbook module. In the upper left pull-down, select Workbook in the upper right pull-down, select

Re: Re: $$Excel-Macros$$ Problem in Salary Slip

You can take idea from what I have done in the attached file. On Tue, Nov 16, 2010 at 3:38 PM, Surendra wrote: > Good After Noon Team, > > Still, Waiting for your response. > > > Regards, > Surnedra > > > On Mon, 15 Nov 2010 15:28:43 +0530 wrote > > >Hi Team, > > > > > > I need your help for c

Re: Re: $$Excel-Macros$$ Problem in Salary Slip

Good After Noon Team, Still, Waiting for your response. Regards, Surnedra On Mon, 15 Nov 2010 15:28:43 +0530 wrote >Hi Team, > > I need your help for calculating Last Working Date from attached format. > > As per policy below mention attendance legends count as a working day > P Present > H

$$Excel-Macros$$ Re: Grouping 20 ppl in 4 groups with 5 ppl in each, and repeat this 5 times - aim for as few repeats as possible..

Hi, In case you are using Excel 2007 or can use Analysis ToolPac you can use =randbetween (lower_limit, upper_limit) with 1 as lower and 5 as upper limit. Otherwise you can use =int(rand( )*100) to generate random integers then divide the numbers by 2, 3, 4, 5, and 6 and select people based on th

RE: $$Excel-Macros$$ VBA Code Required

Dear Members Please Help me I am waiting for reply shrinivas Date: Fri, 12 Nov 2010 13:09:02 +0530 Subject: $$Excel-Macros$$ VBA Code Required From: shrinivas...@gmail.com To: excel-macros@googlegroups.com Dear All Can Anyone help me for following problem. I want to compare 2 column (whic

$$Excel-Macros$$ Intercompany reconciliation

Hello friends, I need to prepare Intercompany reconciliation for my company which includes around 60-70 a/c’s of our intercompany transactions, if anyone doing same kind of job or anyone knowing nice way of doing. Please help me in doing this reconciliation report and understand it better. Thank