Re: Maintaining cell reference after sorting
From: R.VENKATARAMAN ($$$$vram26_at_vsnl@@@@.net&&&)
Date: 11/17/04
- Next message: R.VENKATARAMAN: "Re: Text fields changed to date fields"
- Previous message: Tim W: "FORMAT - Cell Shading"
- In reply to: Deets LaMoss: "Maintaining cell reference after sorting"
- Next in thread: Deets LaMoss: "Re: Maintaining cell reference after sorting"
- Reply: Deets LaMoss: "Re: Maintaining cell reference after sorting"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 17 Nov 2004 08:12:45 +0530
perhaps I have not understood the question. you name a range by siimply
highlight the range and click the arrow to the left of the sign <=> in the
formula bar and type a name and hit <enter>. the range is named. if you
sort the range, the name remains for the range
If this is not what you want apologise.
Deets LaMoss <DeetsLaMoss@discussions.microsoft.com> wrote in message
news:4C4253D4-52FF-4FF5-9F96-B1F60830DF82@microsoft.com...
> Is there a way to maintain a cell reference after sorting a table? I want
to
> identify the row number of a specific cell after sorting. I have tried
using
> "Insert>Name" with both absolute and relative addresses. Neither one
gives
> me what I need. I am literate in VB if I need to write a macro.
>
> Thanks in advance.
- Next message: R.VENKATARAMAN: "Re: Text fields changed to date fields"
- Previous message: Tim W: "FORMAT - Cell Shading"
- In reply to: Deets LaMoss: "Maintaining cell reference after sorting"
- Next in thread: Deets LaMoss: "Re: Maintaining cell reference after sorting"
- Reply: Deets LaMoss: "Re: Maintaining cell reference after sorting"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
