how to insert relative cell references into a vb macro


Posted by Kevin on October 29, 2001 8:47 AM

How do I make my cell references in a macro relative, i.e., if I change the cell location, the cell reference automatically updates. Right now it is not doing this for me. Is this possible?

Thanks,
Kevin



Posted by Juan Pablo on October 29, 2001 10:35 AM

Don't understand what you're trying to do.

Are you creating formulas ? are you doing calculations, formatting, etc. with a range of cells ? can you explain a little more please ?

Juan Pablo