MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




omit hidden rows

This is a discussion on omit hidden rows within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Is it possible to hide rows in excel and have MapPoint skip/omit the data from those rows when mapping? Thanks! ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-09-2008
Junior Member
White Belt
 
Join Date: Jun 2008
Posts: 2
omit hidden rows

Is it possible to hide rows in excel and have MapPoint skip/omit the data from those rows when mapping? Thanks! E
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 06-11-2008
Senior Member
Blue Belt
 
Join Date: Dec 2002
Posts: 248
Re: omit hidden rows

Hi Erika,

You need to consult the lookup functions in Excel help
and then, from a different worksheet, write spreadsheet
or VBA code that will evaluate the cells and return only
valid rows.

Mike Mattys
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 06-11-2008
Junior Member
White Belt
 
Join Date: Jun 2008
Posts: 2
Re: omit hidden rows

Thank you for the info! Erika
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
hidden, omit, rows


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
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
Access some hidden features in MapPoint2002 ActiveX control baal_2000 MapPoint 2006/2009 Discussion 43 08-29-2006 11:46 AM
hidden message Anonymous General Chat 1 04-04-2005 07:53 AM


All times are GMT -5. The time now is 10:47 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54