nge("whatever is chosen"),
Wonder if the following would work?:
Selection.Sort Key1:=ActiveCell, ...
> Paul
>
>
>
> - Original Message
> > From: Tom
> > To: MS EXCEL AND VBA MACROS
> > Sent: Fri, November 5, 2010 8:38:06 AM
&g
o see that the target.count = 1
(in case multiple cells are selected)
Are you familiar enough with VBA to do this? or do you need more assistance?
Paul
- Original Message
> From: Tom
> To: MS EXCEL AND VBA MACROS
> Sent: Fri, November 5, 2010 8:38:06 AM
> Subject: $$Exce
My dataset occupies 50 rows by 20 columns which I defined as my
"database".
There is no difficulty if I choose to sort the "database" either by a
known column or row.
But what I really want the program to do is to sort it by column
wherever the active cell
happens to be - whose location is unknown.
