Finding same cell

W

Wayne Burritt

Hi: I have a series of summary cells from a list that is always changing.
Therefore the address of the cell is always changing...

B
216 Return 04
217 100

B
223 Return 03
224 200

etc...

I 've programmed a macro to make calculations based on these cell locations,
but everytime I add a row, I have to redirect the macro. Any ideas? Wayne
 
F

Frank Kabel

Hi
one way: define a name for this cell and reference this
name within your macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find matching cell and return value of a different cell 5
Highlight rows if column A matches but B is different 0
CELL CONTENTS WRITE TO TAB NAME 0
Hiding/Exposing Rows based on a cell value 10
Adding data from multiple cell and linking to a new worksheet 3
XL2003: INDIRECT() function changes calling cell 0
data filter criteria based on cell references? 1
how to create macro to use cell references for data filter criteri 3

Top