Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-11-2011, 02:40 AM
Catalin.B Catalin.B is offline Generic range for custom sort macro? Windows Vista Generic range for custom sort macro? Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

you better remove ActiveCell. from this line



.SetRange ActiveCell.Range(ActiveSheet.Cells(1, 1), ActiveSheet.Cells(1042, 3))
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Generic range for custom sort macro? Creating a generic macro? suerose Word 2 07-04-2011 07:59 PM
Create Custom menu using a macro twnty2 PowerPoint 0 06-29-2011 04:26 PM
Sort Range boutells Excel 1 07-15-2009 03:02 AM
Generic range for custom sort macro? Sort By Last Name in a List eliz.bell Word 8 05-07-2009 01:33 PM
Weird problem with generic file icons in Office 2K bankboysb Office 0 01-23-2006 02:10 PM

Other Forums: Access Forums

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


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