| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last cell in range
Below is a code I saw in a post that selects the last cell
in columnA that has a value. It skips blank cells. How do I make it select the first cell in the range that has no value. And also(2nd modification) how do I make it select the first cell in the range that has no value skipping blank? Range("A65536").End(xlUp).Select |
| 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) | |||
![Todd Huttenstine[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
