+ Reply to Thread
Results 1 to 2 of 2

Help needed with Hot Spot Geographical Map

  1. #1
    Registered User
    Join Date
    10-02-2013
    Location
    Leeds
    MS-Off Ver
    MS 365
    Posts
    23

    Help needed with Hot Spot Geographical Map

    Does anyone know what the the (10, 6) refer to in this vba script it would be used on the sheet containing data which in turn colour codes a geogreaphical map accordingly. My first thoughts were that it was referring to the rows at the top, perhaps starting at 10, moving to 6.


    If MapSheet.Cells(10, 6)="Crime" Then

    RRef= 50

    Any help greatly appreciated


    Any help greatly appreciated.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,833

    Re: Help needed with Hot Spot Geographical Map

    The 10 refers to the row number and the 6 to the column number therefore it refers to cell F10.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Cheking for close geographical points by geographical coordinates
    By simone77 in forum Excel General
    Replies: 6
    Last Post: 07-04-2014, 10:34 AM
  2. Find Geographical Center Point
    By Olasin in forum Excel General
    Replies: 3
    Last Post: 07-28-2007, 04:24 PM
  3. geographical regions
    By tbcwarrior in forum Excel General
    Replies: 1
    Last Post: 06-15-2007, 12:30 PM
  4. Geographical Charts
    By scaz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-13-2005, 03:05 AM
  5. how do I insert a geographical map
    By Bill K in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-06-2005, 10:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1