View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
manfareed manfareed is offline
external usenet poster
 
Posts: 94
Default Identify Last Cell and autofill last column

Hi,
I have a spreadsheet for which I need to identify the last cell with data
[nos. or formula] and on the column to the right I need to autofill with row
nos. Row numbering should stop when the row with the last cell is reached. Eg
if data is to row 672 only then the row number should be "numbered" as 672.

Thanks,

Manir