What is function to select only not empty cells in a column (like SHIFT+END+ArrowDown or UP)
 

I want to select only cells with something inside not empty. For
example:
I want to find a function in VBA witch work like SHIFT+END+"ArrowDown
or Up"
I have
_____A_____B____
1 | string | |
2 | string | |
3 | string | |
4 | string | |
...........................
40| string | |
41| | |
Cell A41 is empty
I want to select only cells from A1 to A40 , but I dont want to use
something like this (from
Cells A1 to Cells A40 Select) I want to find a function which will do
it automaticaly without
enetering number of cells like from A1 to A40 Select.
Do you know is there a special function in Excel.
If you write some text in column A like mentioned above and go with
cursor on cel A1 than
turn holdSHIFT+ END + DownArrow than it select cells witch text inside
from A1 to A40, how to do something like this in VBA??
Thank you for response

What is function to select only not empty cells in a column (like SHIFT+END+ArrowDown or UP)
 

Dim rng as Range
set rng = Range(Range("A1"),Range("A1").End(xldown))
rng.select

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
I want to select only cells with something inside not empty. For
example:
I want to find a function in VBA witch work like SHIFT+END+"ArrowDown
or Up"
I have
_____A_____B____
1 | string | |
2 | string | |
3 | string | |
4 | string | |
..........................
40| string | |
41| | |
Cell A41 is empty
I want to select only cells from A1 to A40 , but I dont want to use
something like this (from
Cells A1 to Cells A40 Select) I want to find a function which will do
it automaticaly without
enetering number of cells like from A1 to A40 Select.
Do you know is there a special function in Excel.
If you write some text in column A like mentioned above and go with
cursor on cel A1 than
turn holdSHIFT+ END + DownArrow than it select cells witch text inside
from A1 to A40, how to do something like this in VBA??
Thank you for response

What is function to select only not empty cells in a column (like SHIFT+END+ArrowDown or UP)
 

Thanks for Answer. I will try to do this

What is function to select only not empty cells in a column (like SHIFT+END+ArrowDown or UP)
 

Hello
How can I do something like this I want to add to all cells in range
Range("A:A").SpecialCells(xlCellTypeConstants) a prefix string like UT_
for example. I know there is a "character" but how i can use it for ma
Range
____A_____B____
1 | UT_string | |
2 | UT_string | |
3 | UT_string | |
4 | UT_string | |
...........................
40| UT_string | |
41| | |
Thanks for response