MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?


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