Function IN VBA

[mar_male]

Hello,
What is a function in VBA witch do something like key combination
SHIFT+END+("DownArrow" or "ArrowUP")??

I want to select only cells with something inside not empty. For
example:
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

 

[Guest]

If you have the first cell in the range selected the below line of code is
the equivalent to holding down the shift key and pressing the down arrow.

Range(Selection, Selection.End(xlDown)).Select

Hope this helps.

Thanks,
Bill Horton

 

[mar_male]

Thanks for Answer. I will try to do this

 

[mar_male]

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