Posted to microsoft.public.excel.programming

Phil H[_2_] Phil H[_2_] is offline

external usenet poster

Posts: 87

Counting Highlighted Rows

Works great. Thanks, Luke.

"Luke M" wrote:

Sub HowMany()
MsgBox Selection.Rows.Count
End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Phil H" wrote:

I am highlighting rows beyond what I see on screen. Can someone give me a
macro that counts the number of highlighted rows.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Too many rows highlighted	RLD	Excel Worksheet Functions	1	March 24th 10 04:33 PM
Highlighted rows	Reyes	Excel Discussion (Misc queries)	2	November 13th 08 06:58 PM
Counting highlighted cells	Kassie	Excel Discussion (Misc queries)	2	May 8th 08 04:50 PM
Counting highlighted cells?	Josh - Westfield Australia	Excel Discussion (Misc queries)	2	April 20th 05 09:20 AM
counting a highlighted cell	Dragonstear	Excel Programming	1	October 17th 03 03:44 AM

All times are GMT +1. The time now is 07:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us