Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2009, 02:24 AM
boutells boutells is offline Sort Range Windows Vista Sort Range Office 2007
Novice
Sort Range
 
Join Date: May 2009
Posts: 24
boutells is on a distinguished road
Default Sort Range

Is there a way of devining a range to be sorted without dragging the mouse over it in the first instance. I am trying to do this in a macro but whenever I go to sort it elects the range automatically and when I hit escape to get out of it, it exits the sort procedure completely.
Reply With Quote
  #2  
Old 07-15-2009, 03:02 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Sort Range Sort Range Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

When you say that you want to devine a range do you mean like this:

  1. Get the formula to go to a specific cell or range (ie. A1 or A1:F1)
  2. then find where the information in that column ends (ie. go down the column(s) until you encouter a blank cell)
  3. then pass this range to the next part of your script (ie. A1:A254 or A1:F254)?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort Macros boutells Excel 1 07-16-2009 11:48 AM
Sort Range Range Formula aleksandr Excel 10 05-18-2009 12:14 PM
Sort Range Sort By Last Name in a List eliz.bell Word 8 05-07-2009 01:33 PM
Printing a Page Range cmc Word 0 04-20-2009 10:32 AM
Sort Range Subscript out of range error KHTAY Excel 6 03-28-2009 11:18 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft