Anchoring

T

Tobias

Hello

I have a problem. I have a worksheet with collected cells (e.g. in cell A2 is Sheet3!D2) from different other sheets. I am then using this sheet, via VBA, to create a new list suited to create a Pivottable. This new list then of course get new cell references from the new sheet. So what I want to do is to give all my cells (52 * 800 cells) an anchored value. Is there a way to add dollar signs before and after the D in my example..(instead of Sheet3!D2 i want Sheet3!$D$2)?
 
S

Steven

make sure you can see the formula bar, tools > options > view > formula bar,

click on the cell that contains your formula, then click on the formula bar
and press F4, cycle through until its as you require,

Steve

Tobias said:
Hello,

I have a problem. I have a worksheet with collected cells (e.g. in cell A2
is Sheet3!D2) from different other sheets. I am then using this sheet, via
VBA, to create a new list suited to create a Pivottable. This new list then
of course get new cell references from the new sheet. So what I want to do
is to give all my cells (52 * 800 cells) an anchored value. Is there a way
to add dollar signs before and after the D in my example..(instead of
Sheet3!D2 i want Sheet3!$D$2)?
 

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

Top