LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default Township Range map in Excel

Has anyone heard of an add-in or has anyone developed code where a
township-range map can be drawn in Excel by extracting data from the legal
description such as the following:
T155 R95 Sec30: NW4

Each cell in a worksheet represents a 40 acre quarter of a quarter section.
Ideally the above legal description would color the corresponding cells in
the worksheet. For example, the above legal description would color the
following cells with X's (A1 through B2, the NW quarter) a certain color:


A B C D
--- --- --- ---
1 | | | | |
| X | X | | |
--- --- --- ---
2 | | | | |
| X | X | | |
--- --- --- --- <Section
3 | | | | |
| | | | |
--- --- --- ---
4 | | | | |
| | | | |
--- --- --- ---

This would be one section of 36 sections in a township. Any and all
suggestion are welcome.


 
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
RANGE EXCEL copy cell that meets criteria in a range confused Excel Worksheet Functions 3 March 27th 08 01:41 PM
Excel Addin:Setting the range to the Excel.Range object range prop Rp007 Excel Worksheet Functions 5 November 24th 06 04:30 PM
Excel 2000 VBA - Set Print Range in dynamic range sub_pop[_5_] Excel Programming 2 July 27th 04 08:01 PM
adding reference-to-range control to excel range Nir Sfez Excel Programming 1 March 2nd 04 06:11 PM
Range.Formula and Range question using Excel Automation [email protected] Excel Programming 0 September 19th 03 04:53 AM


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