Thread: select cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anna Anna is offline
external usenet poster
 
Posts: 132
Default 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