Sorting
 

Hi,

I'm trying to pass the values/contents of key1 and key2 from the sort method
to separate variables. Essentially I am trying to check the sort parameters,
replace the data with an updated dataset, and then reinstate the sort. I'm
not actually trying to sort, just check the current sort characteristics!

So I tried to pass the contents of key1 and key2 to variables as show below:

With Selection.Sort
vkey1 = .key1
vkey2 = .key2
End With

Unfortunately I got an "Unable to get the Sort property of the Range class."
error.

Could someone please help!

Thanks,

Jill E

Sorting
 

Jill,

AFAIK, the sort method doesn't have any user readable properties.

HTH,
Bernie
MS Excel MVP

"Jill E" wrote in message
.. .
Hi,

I'm trying to pass the values/contents of key1 and key2 from the sort
method
to separate variables. Essentially I am trying to check the sort
parameters,
replace the data with an updated dataset, and then reinstate the sort. I'm
not actually trying to sort, just check the current sort characteristics!

So I tried to pass the contents of key1 and key2 to variables as show
below:

With Selection.Sort
vkey1 = .key1
vkey2 = .key2
End With

Unfortunately I got an "Unable to get the Sort property of the Range
class."
error.

Could someone please help!

Thanks,

Jill E

Sorting
 

Thanks for the info.
Does you know of another way in which to determine the current sort
settings?

Jill E
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Jill,

AFAIK, the sort method doesn't have any user readable properties.

HTH,
Bernie
MS Excel MVP

"Jill E" wrote in message
.. .
Hi,

I'm trying to pass the values/contents of key1 and key2 from the sort
method
to separate variables. Essentially I am trying to check the sort
parameters,
replace the data with an updated dataset, and then reinstate the sort.
I'm
not actually trying to sort, just check the current sort
characteristics!

So I tried to pass the contents of key1 and key2 to variables as show
below:

With Selection.Sort
vkey1 = .key1
vkey2 = .key2
End With

Unfortunately I got an "Unable to get the Sort property of the Range
class."
error.

Could someone please help!

Thanks,

Jill E