VBA - Cell Constant

  • Thread starter Thread starter bforster1
  • Start date Start date
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??
 
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
 
You must log in or register to reply here.

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

HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ? 12
VBA: Column Select then Data Select then return to cell A1 3
Keeping a cell or value constant in further equations 1
repeat calculation for different combination of input? 11
Freeze filename and path in cell 2
Generating a Table of Results 4
complex custom fill series with formula 4
Copy/Paste formulas in merged cells 2

Back
Top