Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a range of cells, how to ?
Hello,
I have a problem with selecting cells. The selection allways goes from column A to M. The number of rows starts allways from A 11, to the LAST CELL in column A which contains a number So the column range is fix, and the row range is variable. For example : It can be A11 to M24 or A11 to M5 or A11 to M11 (this is only 1 row) What code should i use in the macro ? Thanxx Luc -------------------------------------------------------------------------------- Mijn Postvak In wordt beschermd door SPAMfighter 301 spam-mails zijn er tot op heden geblokkeerd. Download de gratis SPAMfighter vandaag nog! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a range of cells, how to ?
Luc, if the space underneath the last number in column A is always empty, try
this: Range("A11:M" & Range("A" & Rows.Count).End(xlUp).Row)).Select -- Charles Chickering "A good example is twice the value of good advice." "Luc" wrote: Hello, I have a problem with selecting cells. The selection allways goes from column A to M. The number of rows starts allways from A 11, to the LAST CELL in column A which contains a number So the column range is fix, and the row range is variable. For example : It can be A11 to M24 or A11 to M5 or A11 to M11 (this is only 1 row) What code should i use in the macro ? Thanxx Luc -------------------------------------------------------------------------------- Mijn Postvak In wordt beschermd door SPAMfighter 301 spam-mails zijn er tot op heden geblokkeerd. Download de gratis SPAMfighter vandaag nog! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting a range of cells , how to ? | Excel Programming | |||
Selecting a range of cells, how to ? | Excel Worksheet Functions | |||
Range selecting cells | Excel Discussion (Misc queries) | |||
Help with selecting a range of cells | Excel Programming | |||
Selecting a range of cells | Excel Programming |