Thread: Halfway to End
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Halfway to End

65536 wont be true with next xl version

column's cells


--
Don Guillett
SalesAid Software

"Gary''s Student" wrote in message
...
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?