Slight problem

**Glenn Kilpatric** · 10-20-2006, 03:24 PM

A friend wrote me a spreadsheet for our fishing club league. I recently got some help in updating it from the kind folk of this forum.

I have a slight problem though. My recap page sorts anglers into a league table with the angler with the heaviest weight of fish at the top of the league and the angler with least weight of fish in the last position.

However ther are 2 columns of the league that arent being sorted for some reason. I have 2 anglers who should be middle of the league but they are appearing at the bottom. There weights are correct but they arent being included in the sort.

Would someone be kind enough to help me please.

http://www.whitbyseaanglers.co.uk/06-07-matches(2).xls

**raypayette** · 10-20-2006, 05:56 PM

It's the problem of the fish that got away.
Perhaps you used the wrong lure?

**Glenn Kilpatric** · 10-22-2006, 04:57 AM

No ideas ?

This is the copy and pasted league table. The bottom 2 anglers havent been included in the sort.

http://www.whitbyseaanglers.co.uk/positions-06-07.php

**Bryan Hessey** · 10-22-2006, 05:57 AM

Originally Posted by Glenn Kilpatric

No ideas ?

This is the copy and pasted league table. The bottom 2 anglers havent been included in the sort.

http://www.whitbyseaanglers.co.uk/positions-06-07.php

The sort covers the range

Range("A3:E34").Select

only.

You need to set it to

LastRow = Sheets("Recap").Range("E65536").End(xlUp).Row
Range("A3:E" & LastRow).Select

---

Press Alt/F11 and view Module (or Edit Macro 'SortIt') replace the red with the blue text.

hth
---

Slight problem

LinkBack

Thread Tools

Rate This Thread

Display

Slight problem

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions