| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range to Last Cell
I am writing an Excel 2002 template and wish to use VBA to 'highlight' a
range from A3 to the last cell. The row of the last cell will vary but will always be in column N. My VBA knowledge is limited. I have tried and failed with Range ("A3").SpecialCells(xlLastCell).Activate and I am not sure if I need 'Select' or 'Activate' to 'highlight' the range. When complete, the worksheet view should show A1 as the top left (home) cell rather than (for example) N999 at the bottom right. Thanks in anticipation. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
| RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
| copy range and paste into every 3rd cell of new range | New Users to Excel | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
![Grey Old Man[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
