ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Selecting a Range (https://www.excelbanter.com/excel-programming/428186-selecting-range.html)

Sue

Selecting a Range
 
I wish to select the range from the active cell to a3.
Range("ActiveCell:a3").Select needs debugging. help!
Sue

Jacob Skaria

Selecting a Range
 
Range(activecell.Address & ":A3").select
--
If this post helps click Yes
---------------
Jacob Skaria


"Sue" wrote:

I wish to select the range from the active cell to a3.
Range("ActiveCell:a3").Select needs debugging. help!
Sue


Nigel[_2_]

Selecting a Range
 
Range(ActiveCell, Range("A3")).Select

--

Regards,
Nigel




"Sue" wrote in message
...
I wish to select the range from the active cell to a3.
Range("ActiveCell:a3").Select needs debugging. help!
Sue




All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com