|
|
|
|
#1
08-11-2011, 12:35 AM
|
|||
|
|||
you can change this line to this one: .SetRange ActiveCell.Range(ActiveSheet.Cells(1, 1), ActiveSheet.Cells(1042, 3)) to set the range to rows 1 to 1042, col 1 to 3, in this example but your macro works weird 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 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 |
|
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 |
Windows Vista 
Office 2007
Hybrid Mode