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
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.
>
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
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
--
--
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.
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
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
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
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
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
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
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
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
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
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
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
16 matches
Mail list logo