View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
David Turner David Turner is offline
external usenet poster
 
Posts: 50
Default Inserting value at end of range

Dave Peterson wrote

It's the equivalent of
Range("A" & Rows.Count).End(xlUp).offset(1,0)

(it comes down one row.)

Alan Beban has some notes at Chip Pearson's site that you may want to
read/print that have some more variations for using ranges.
http://www.cpearson.com/excel/cells.htm


Thanks.

--
David