Results 1 to 4 of 4

Macro: assign value of x-y postion

Threaded View

  1. #1
    Registered User
    Join Date
    05-17-2011
    Location
    Limerick, Ireland
    MS-Off Ver
    Excel 2003
    Posts
    2

    Cool Macro: assign value of x-y postion

    Hi,

    I need to create a macro which will give the cell of a co-ordinate a value of 1.

    Basically I have two columns called X-Position and Y-Postion e.g.

    X-Position Y-Position
    2 16
    6 9

    So the marco will take the 2nd row 16th column in and assign that cell the value 1 then take the 6th row and 9th column in assign give the cell value 1 and so on...
    Last edited by james.carey; 05-17-2011 at 12:23 PM.

Thread Information

Users Browsing this Thread

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

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