Anchoring

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)?
 
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
Click to expand...
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)?
 
Back
Top