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! |
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! |
All times are GMT +1. The time now is 08:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com