Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select cells in a column
I need to select all the cells in Column K that have a value. It starts with
K3 and can be any number of cells below, but there are never blank cells mixed in - its always consecutive. Here is what I have. It works, but seems "sloppy" for lack of a better word: ActiveSheet.Range(range("k3"),Cells(ActiveSheet.Ra nge("A65536").End(xlUp).Ro w, 11)).select Is there a way to refer to the last used cell in column K without using the Cells method? Meaning a literal way such as: Range("k3",ActiveSheet.Range("K65536").End(xlUp).R ow, K) Obviously this doesn't work, but I was looking for something without using the numeric index of the column. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select cells in a column
Hi Evan,
Is there a way to refer to the last used cell in column K without using the Cells method? Meaning a literal way such as: Simply replace the column number with the correspondinf column letter in your expressions. For example, the expressions cells(1,4) and cells(1,"D") are completely equivalent. --- Regards, Norman. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select cells in a column
Evan wrote:
I need to select all the cells in Column K that have a value. It starts with K3 and can be any number of cells below, but there are never blank cells mixed in - its always consecutive. Here is what I have. It works, but seems "sloppy" for lack of a better word: ActiveSheet.Range(range("k3"),Cells(ActiveSheet.Ra nge("A65536").End(xlUp).Ro w, 11)).select Is there a way to refer to the last used cell in column K without using the Cells method? Meaning a literal way such as: Range("k3",ActiveSheet.Range("K65536").End(xlUp).R ow, K) Obviously this doesn't work, but I was looking for something without using the numeric index of the column. thanks Set rng = Range("K1") Range(rng(3), rng(rng(65536).End(xlUp).Row)).Select Alan Beban |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select cells in a column
Try.....
Range("K3:K"& Cells(Rows.Count, "K").End(xlUp).Row).Select Cheers Nigel "Evan" wrote in message ... I need to select all the cells in Column K that have a value. It starts with K3 and can be any number of cells below, but there are never blank cells mixed in - its always consecutive. Here is what I have. It works, but seems "sloppy" for lack of a better word: ActiveSheet.Range(range("k3"),Cells(ActiveSheet.Ra nge("A65536").End(xlUp).Ro w, 11)).select Is there a way to refer to the last used cell in column K without using the Cells method? Meaning a literal way such as: Range("k3",ActiveSheet.Range("K65536").End(xlUp).R ow, K) Obviously this doesn't work, but I was looking for something without using the numeric index of the column. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Select Repeating Cells in a Column | Excel Worksheet Functions | |||
How do you select all text/data within all the cells of a column? | Excel Discussion (Misc queries) | |||
How to select certain cells in a column ? | Excel Discussion (Misc queries) | |||
How do I select cells within a column that contain a specific word | Excel Worksheet Functions | |||
Column Width for a select # of cells | New Users to Excel |