Because a column always contains 65536 cells, the bottom half is 32769 thru
65536. For example:

Sub gsnu()
Range("A32769:A65536").Select
End Sub
--
Gary's Student


"Rokuro kubi" wrote:

How do I select the bottom half of a column's cells in a macro?