Excel 2007 : Excel 2007 - Named range disappears in sort macro

**bungaree** · 07-12-2008, 06:39 PM

I have several named ranges which are sorted individually. These ranges change, ie rows are added and deleted, hence the need for named ranges. Have been using this extensively in 2003 without any issue.

Now I've recorded a macro in 2007 to sort ranges, however within the actual macro, though it starts with Goto Reference:="dataA" (dataA = named range), the actual sort refers to columns & rows, ie B4:F70.

The range in the example above has grown to B4:B95, but is only being sorted up to row 70 as per the macro.

What can I do to keep the named range as the sort range within the macro?

Bungaree

**shg** · 07-12-2008, 08:14 PM

Post the code?

**bungaree** · 07-12-2008, 08:50 PM

SHG,

I made the earlier one up, as the situation of several ranges is actually at work and I'm at home.

I discovered the 2007 problem in the macro below. I must have recorded it when there were 240 records and it was only sorting 240 rows though I had inserted about 50 more - I've solved it for this particular worksheet by making the range far larger than I'll ever need - a quick (ugly) fix for this one.

I do have other situations where the range needs to be flexible and would like to know why 2007 is causing probs with this.

Thanks in anticipation!
Bungaree

Please Login or Register  to view this content.

**royUK** · 07-13-2008, 03:13 AM

bungaree

You need to read the Forum Rules & use Code Tags when posting code. I will add them this time, but next ime you my find your post closed.

Excel 2007 : Excel 2007 - Named range disappears in sort macro

LinkBack

Thread Tools

Rate This Thread

Display

Excel 2007 - Named range disappears in sort macro

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions