Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Turquoise_dax
 
Posts: n/a
Default What does a blue row number means?


I have a problem: I can't show some rows after they've been hidden with
a macro. I tryed the "select all / unhide", but it doesn't work.

I noticed the row numbers are all blue now. What does it mean? (This
could be the answer..:P)


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=553711

  #2   Report Post  
Posted to microsoft.public.excel.misc
Allllen
 
Posts: n/a
Default What does a blue row number means?

are they filtered using the autofilter?
Can you turn this off? (data filter autofilter)
--
Allllen


"Turquoise_dax" wrote:


I have a problem: I can't show some rows after they've been hidden with
a macro. I tryed the "select all / unhide", but it doesn't work.

I noticed the row numbers are all blue now. What does it mean? (This
could be the answer..:P)


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=553711


  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default What does a blue row number means?

The blue row numbers indicate you r rows are in filter mode.

Try DataFilter and turn off Autofilter or undo an Advanced Filter.


Gord Dibben MS Excel MVP

On Tue, 20 Jun 2006 11:33:54 -0500, Turquoise_dax
wrote:


I have a problem: I can't show some rows after they've been hidden with
a macro. I tryed the "select all / unhide", but it doesn't work.

I noticed the row numbers are all blue now. What does it mean? (This
could be the answer..:P)


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
number format Ivan Excel Discussion (Misc queries) 2 October 14th 05 02:08 PM
vlookup with more than number to be retrieved martelie Excel Worksheet Functions 1 October 8th 05 07:33 AM
Named Ranges shown (or not shown) as blue means what? wdeleo Excel Worksheet Functions 0 July 8th 05 01:40 PM
Count Number of Characters in a cell? AHJuncti Excel Discussion (Misc queries) 2 June 16th 05 07:39 PM
Need number of Saturdays and number of Sundays between 2 dates Class316 Excel Worksheet Functions 1 June 10th 05 02:47 AM


All times are GMT +1. The time now is 04:18 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"