VBA - Cell Constant

B

bforster1

I have created code that inserts lines into a financial statement but
need to have certain cells in other code stay constant.

B1 in certain code must stay at B1 regardless of changes to the
spreadsheet.

Any suggestions??
 
C

Chip Pearson

Use the INDIRECT function. E.g.,

=INDIRECT("B1")

The B1 will remain so regardless of inserting and deleting rows.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top