LinkBack URL
About LinkBacks
im trying to sort using vba, i have the code to select the cell i want to start with.
i want to use xlDown and xlToRight to select my range.
heres my code, how can i make it work?
Please Login or Register to view this content.
im trying to sort using vba, i have the code to select the cell i want to start with.
i want to use xlDown and xlToRight to select my range.
heres my code, how can i make it work?
Please Login or Register to view this content.
Try
It's a good idea to set the value of Header to xlYes or xlNo in case the guess is wrong.Please Login or Register to view this content.
Originally Posted by mrice
Try
It's a good idea to set the value of Header to xlYes or xlNo in case the guess is wrong.Please Login or Register to view this content.
Im a rookie with vba so im not too sure what your last sentence means? sorry.
also im still erroring out when executing the code, i get run time error 1004 Method 'Range' of object'_Global' failed
did the code execute on your end?
thanks for the help!
Try with less brackets
Excel will make a guess as to whether there is a header row in the range or not based upon the cell contents. Sometimes it gets it wrong hence the suggestion you should specify if there is a header row or not.Please Login or Register to view this content.
Last edited by mrice; 09-24-2013 at 03:46 PM.
perfect! code is flawless. thanks for the help!
The ActiveCell is on the ActiveSheet. If you want to use that in figuring out what to sort, you need to select the sheet first.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks