Thread: Insert & Sequentially Number Column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ingolf Ingolf is offline
external usenet poster
  
Posts: 32
Default Insert & Sequentially Number Column
Hi,

instead of Cells(2, 1).End(xlDown)

use Cells(Rows.Count, 1).End(xlUp)

to refer to the last cell containing data in column A.

Regards,
Ingolf

Reply With QuoteReply With Quote