Create Identifier for cell(s)

[bhardage]

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.

[broro183]

Hi BJ,

Afaik there is nothing similar to the "class" attribute. You could identify the cells by having a hidden comment attached to the relevant cells or using Insert Names..., or identify if all cells are in a single column or maybe static variable that holds the cell address after deletion etc...

Can you please attach a sample workbook to provide more context which may help us provide another (more efficient) solution?
(for me to help, please attach it as Excel 97-2003 compatible .xls format)


Edit: Ooopps, after posting I realised this thread had been listed as "solved". BJ, can you please post your solution?
This makes the forum more usable for people who search existing threads to find solutions to their own problems.

Rob