with activesheet.range("a1").currentregion
.cells(.cells.count).select
end with

Dave Peterson wrote:

with activesheet.currentregion
.cells(.cells.count).select
end with

Luc wrote:

Within a 'CurrentRegion.Select' i want to select the bottom right cell in
this selection.
What code should i use.

Thanxxx

Luc

--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
340 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!

--

Dave Peterson

--

Dave Peterson