Picking a range out of a larger range with tightest data set

Hello All,

I am trying to write a sub that will find a range of sixty cells inside a range of ninety cells whose maximum value minus the minimum value is the smallest. I wrote the following code:

Please Login or Register  to view this content.

When I try to run this sub, a message box informs me that I have a type mismatch. Any help would be greatly appreciated.

hello,

Replace all your + signs with the & and you should be there.
In your macro press ctrl + h and fill in the files, enter and finished.

reg.
Demeter

Thanks Demeter,

I incorporated your changes and now I'm not getting any error messages, but absolutely nothing happens. I tried inserting a command button, but nothing happens. Are there any other possible issues?

Please Login or Register  to view this content.

Thanks to all who have suggestions.

Thanks, StephenR, your changes fixed everything.