Macro sort

E

Excel user

I am having a hard time using macros to sort numbers. After I recorded the
sort colum that contained numbers and run macro on another excel sheet, it
doesn't work. What should be done to make it works?
Thanks
 
G

Gord Dibben

You probably have a hard-coded sheet reference like "Sheet1"

Change it to ActiveSheet


Gord Dibben MS Excel MVP

On Fri, 1 Aug 2008 11:40:20 -0700, Excel user <Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro warning in word 1
Need Help with Macro Security 1
Cannot sort a table containing text 5
Drop down list control value in vba 2
Cell data entering slow! 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Macro to copy table of contents to a new doc 0
Sorting rows 16

Top