Results 1 to 2 of 2

Create Identifier for cell(s)

Threaded View

  1. #1
    Registered User
    Join Date
    05-20-2009
    Location
    Jonesboro, AR
    MS-Off Ver
    Excel 2007
    Posts
    6

    Create Identifier for cell(s)

    I'm working on the following macro:

    A row contains a drop-down list that, depending on the selection, adds or deletes rows below the current row. The initial row and the added rows comprise a single "entry," and there are multiple entries.

    My problem lies in that right now the VBA script I've written to perform this task has the first drop-down list's cell number hard-coded. This could be OK, except I need to apply the same functionality to the drop-down lists of all the entries, and since rows are being added and deleted constantly, their locations keep changing.

    I was wondering if there was a way to identify a cell (that's not unique) that I could check for, analogous to the "class" attribute in HTML.

    Or, is there another way to do what I'm wanting that I'm not thinking of.

    Thanks for your help,
    B.J.
    Last edited by bhardage; 05-21-2009 at 03:29 PM.

Thread Information

Users Browsing this Thread

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

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