How to select the bottom right cel in a 'CurrentRegion.selecion'
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
|