As Range
> >
> > > > > ActiveCell.CurrentRegion.Select
> >
> > > > > Set rng = Selection
> >
> > > > > ActiveCell.Resize(1, rng.Columns.Count).Interior.Color = 15773695
> >
> > > > > rng.Cells(rng.Rows.Count, 1).Res
veCell.Resize(1, rng.Columns.Count).Interior.Color = 15773695
>
> > > > rng.Cells(rng.Rows.Count, 1).Resize(1,
> > rng.Columns.Count).Interior.Color =
> > > > 15773696
>
> > > > End Sub
>
> > > > Rajan
>
> > > > *From:* excel-macros@g
t;
> > > > ActiveCell.CurrentRegion.Select
> > >
> > > > Set rng = Selection
> > >
> > > > ActiveCell.Resize(1, rng.Columns.Count).Interior.Color = 15773695
> > >
> > > > rng.Cells(rng.Rows.Count, 1).Resize(1,
> > rng.Colum
t; 15773696
> >
> > > End Sub
> >
> > > Rajan
> >
> > > *From:* excel-macros@googlegroups.com [mailto:
> > > excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> > > *Sent:* Wednes
Columns.Count).Interior.Color =
> > 15773696
>
> > End Sub
>
> > Rajan
>
> > *From:* excel-macros@googlegroups.com [mailto:
> > excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> > *Sent:* Wednesday, June 08, 2011 4:01 PM
> > *To:* excel-ma
om:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Wednesday, June 08, 2011 4:01 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Current Region
>
>
>
> Hi,
>
>
>
> P
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Wednesday, June 08, 2011 4:01 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Current Region
Hi,
Please find attached file here I want to highlight first and last row of
Hi,
Please find attached file here I want to highlight first and last row of the
region, Please let me know how to do this in VBA.
Thanks,
Chandra Shekar B
--
--
Some important links for excel users:
1. Follow us o
