I must have deleted duplicates or something but now I have a missing row 
numbers in a worksheet. I want a quick check on the number of rows in a 
column from the row numbers. How do I re-number the rows?

How did you name them the first time

-- 
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett@gmail.com
"kingfisher" <kingfisher@discussions.microsoft.com> wrote in message 
news:C9E8C445-AEA2-4131-AF4A-83A4ECFDAF92@microsoft.com...
>I must have deleted duplicates or something but now I have a missing row
> numbers in a worksheet. I want a quick check on the number of rows in a
> column from the row numbers. How do I re-number the rows? 

Are the missing rows hidden?

Do you have a filter in place?

Or are you speaking of row numbers you manually added?


Gord Dibben  MS Excel MVP

On Thu, 21 Jan 2010 14:21:01 -0800, kingfisher
<kingfisher@discussions.microsoft.com> wrote:

>I must have deleted duplicates or something but now I have a missing row 
>numbers in a worksheet. I want a quick check on the number of rows in a 
>column from the row numbers. How do I re-number the rows?