View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pandi Pandi is offline
external usenet poster
 
Posts: 1
Default How to select cells?

I have some table, I want in my VB code to select all the cells in th
table except the header.
How do I do that so if I will want to add in the future another cell
to this table the VBA code will include automatically this cells?

I had try to user the Lines:
Range(ActiveCell, ActiveCell.End(xlDown)).Select
Range(ActiveCell, ActiveCell.End(xToRight)).Select
(The active cell is "A2"

--
Message posted from http://www.ExcelForum.com