Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select cell
My objective is : select a range of cells from A1 to {cell}. {cell} is a
variable that my cursor stays. For example, if my cursor stop at cell h13, the macro will select a1..h13. If my cursor stop at cell h26, the macro will select a1..h26. Is it possible to have this kind of coding? Range("A1:{cell}").Select How can I substitute the selected cell's name into {cell}? Please advise |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
Select First Active Cell if the cell is in a pivot table | Excel Programming |