Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Sorting records with a macro

Hi,

Thanks in advance.

I which to create a macro button that selects all rows (after row 10) that
col b is completed with a number. (With the intention of sorting it later.)

When I write the macro is states the no of rows I have selected. The trick
is I don't know how may rows there are so how do I select just active rows.

Thanks

Trev
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help for Medical Records sorting Gerry St Excel Worksheet Functions 4 April 10th 10 02:35 AM
need help sorting records over multiple worksheets Liz Excel Discussion (Misc queries) 10 November 26th 07 09:26 AM
Sorting Records reese Excel Discussion (Misc queries) 2 April 7th 05 11:02 PM
Sorting and delete records with macro conio96 Excel Programming 1 November 18th 03 10:12 AM
Sorting 100 rows of 6 records horizontally Victor[_3_] Excel Programming 4 October 30th 03 11:38 PM


All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"