Re: Excel Question
 

Thank you,
That worked perfectly.

One more question.

I didn't realize that some less used columns would have blank cells intermixed with numbers.
What would be the function that finds the last entry in a column under these conditions?

Re: Excel Question
 

That's even easier:

Function LastNonBlankValue(range)
For Each entry In range
If entry.Value <> "" Then
LastNonBlankValue = entry.Value
End If
Next
End Function

Enjoy!
-Link

Re: Excel Question
 

Works great!
Thank you much.

WarBus