| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find cell below last number in a column
A bit late but here goes:
Range("C7").Select ActiveCell.End(xlDown).Offset(1, 0).Select 'FINDS LAST NUMBER IN COLUMN C -- Occasionally stumped "Sandy" wrote: what was the method? Thanks "Two-Canucks" wrote: Sorry, found the efficient way in one of the answers. -- Occasionally stumped "Two-Canucks" wrote: I need an efficient way to find the cell below the last number in a column in a macro. Thanks -- Occasionally stumped |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to find the last number of a column (lower cell) | Excel Discussion (Misc queries) | |||
| FInd common data in one column then add number in adjacent column | Excel Worksheet Functions | |||
| Find previous number and find next number in column | Excel Discussion (Misc queries) | |||
| How to find what number in Column A is not included in Column B? | Excel Discussion (Misc queries) | |||
| Find DMIN in a column range determined by a number in another cell | Excel Worksheet Functions | |||
Threaded Mode
