Sorting an Area

[Mike Savage]

I am trying to sort a range but defined by the Row number of a Named Cell "SheetAreaEnd"

The Code I am using is

Please Login or Register  to view this content.

This however gives an error "Run-time error '1004'


If I fix the Range using the code below then it works correctly

Please Login or Register  to view this content.

I can select the correct area using the code

Please Login or Register  to view this content.

Hoping someone can spot the error I have made !

Many thanks
Mike

[beyond Excel]

Hello. I imagine that you intend that the expression:

Range("SheetAreaEnd").Row

return the number '20'.

However, what it will return is the number of the first row of the named range 'SheetAreaEnd': That's your mistake!...

[Mike Savage]

Thanks for this.
Sorry I should have said that the Range "SheetAreaEnd" is actually one cell at the end so giving a Raneg to Sort of C9:AL20

Mike

[beyond Excel]

Upload your sample workbook to the Forum because as far as I can see nothing indicates that you are going to have an error.