Thanks for the quick response, try the following: 1. Highlight a range of data 2. Sort by Ascending order 3. Highlight a different range 4. Now Press F4, nothing happens. In Excel 2003, F4 would have repeated the last command, now in Excel 2007, that does not happen.
Try it and let know if this works for you or not. Thanks On Tue, May 12, 2009 at 2:05 AM, Sachin Shukla <sachina...@gmail.com> wrote: > use CTRL - R > > Thanks > Sachin Shukla > > On Tue, May 12, 2009 at 12:39 AM, Rene Resendez > <resendez.r...@gmail.com>wrote: > >> >> I use to be able to just about use F4 to repeat the last command in >> Excel 2003, my company just upgraded to Excel 2007. Now that function >> is longer available. >> >> Does anyone have any possible solutions. >> >> Thanks in advance to anyone who can help. >> >> >> > > > > -- Rene C. Resendez --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---