Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select the bottom right cel in a 'CurrentRegion.selecion'
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select the bottom right cel in a 'CurrentRegion.selecion'
Dim rng as Range
set rng = Range("B9").currentRegion rng(rng.count).Select or Dim rng as Range set rng = Range("B9").currentRegion rng.Select rng(rng.count).Activate if you want it to the the active cell in multicell selection. -- Regards, Tom Ogilvy "Luc" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select the bottom right cel in a 'CurrentRegion.selecion'
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to define and select the last (bottom) number in a column? | Excel Worksheet Functions | |||
Changing the little tab at the bottom where you select your worksh | Excel Discussion (Misc queries) | |||
Select first row of currentregion | Excel Programming | |||
Select a range in a column in currentregion | Excel Programming | |||
CurrentRegion less one Row | Excel Programming |