What has this got to do with shading rows?
has someone hijacked another's post?
P
From: "Kishan Reddy, K"
To: MS EXCEL AND VBA MACROS
Sent: Fri, September 10, 2010 2:58:35 AM
Subject: Re: $$Excel-Macros$$ Macro to reshade every other row af
Usha,
This function is used mainly in finance. This can be better explained
by an example.
Let us assume, you are having Rs. 1,00,000/- which you want to invest.
You got two proposals.
1. Fixed deposit at 10% interest for five years.
2. an annuity plan :
end of 1st year you wi
Got it working! Here's the final code. I actually have two named
ranges on each worksheet, so the code performs the highlighting for
each.
###
Dim curWks As Worksheet
Dim r As Long
Dim Range1 As Range
Dim Range2 As Range
Set curWks = ActiveSheet
With curWks
If .Name = ("WS1") Then
Set Range
Here is an approach that might work. I'm just not sure of the correct
syntax:
Dim curWks As Worksheet
Dim MyRange as String
Dim r As Long
Set curWks = ActiveSheet
With curWks
If .Name = “WS1” Then MyRange = .WS1Data ' or do you need to say
Set MyRange = .Range(MyRange)
If .Name = “WS2” Th
rt
To: MS EXCEL AND VBA MACROS
Sent: Thu, September 9, 2010 12:11:26 PM
Subject: Re: $$Excel-Macros$$ Macro to reshade every other row after column sort
I don't think the conditional formatting option will work, because the
size of the range changes depending on the data. In other words, there
I don't think the conditional formatting option will work, because the
size of the range changes depending on the data. In other words, there
is no fixed block to select to apply the conditional formula.
On Sep 9, 12:35 am, Dave Bonallack wrote:
> Hi,
>
> I assume your shading is currently done
Dear All,
Can you tell me what is IRR (Internal Rate of Return Calculation) in Excel
and how to use it?
Regards,
Usha
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi,
I assume your shading is currently done manualy.
It could easily done with VBA or even more easily with Conditional formatting,
as long as you aren't currently using it for something else.
Select all cells in the block
Open the conditional formatting dialogue box
Select 'Formula is'
