mbt masai
 
Welcome !
         

                                
After experiencing a lot of down time, We decided to move this site to CrystalTech.com. CrystalTech.com is powered by only the finest Windows servers providing the best performance, reliability, and value anywhere.

 x/y position

Author Message
wmec

  • Total Posts : 159
  • Scores: 0
  • Reward points : 0
  • Joined: 8/5/2004
  • Location: China
  • Status: offline
x/y position Monday, March 08, 2010 3:41 PM (permalink)
0
Hi,
  Dim rFoundCell As Range
  Set rFoundCell = Range("A1")
How do we know the x position and the y position of the cell, for the cell above, by VBA?
#1
    ebgreen

    • Total Posts : 8081
    • Scores: 94
    • Reward points : 0
    • Joined: 7/12/2005
    • Status: offline
    Re:x/y position Monday, March 08, 2010 4:21 PM (permalink)
    0
    The A1 tells you it is the first row, first column. Or in x,y it would be 1,1.
    "... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
    Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
    http://www.visualbasicscript.com/m_47117/tm.htm
    #2

      Online Bookmarks Sharing: Share/Bookmark

      Jump to:

      Current active users

      There are 0 members and 1 guests.

      Icon Legend and Permission

      • New Messages
      • No New Messages
      • Hot Topic w/ New Messages
      • Hot Topic w/o New Messages
      • Locked w/ New Messages
      • Locked w/o New Messages
      • Read Message
      • Post New Thread
      • Reply to message
      • Post New Poll
      • Submit Vote
      • Post reward post
      • Delete my own posts
      • Delete my own threads
      • Rate post

      2000-2012 ASPPlayground.NET Forum Version 3.8
      mbt shoes www.wileywilson.com