Bulk cell anchoring

[MarkAndrews]

I have this table

FE Monthly Analysis.xls
	A	B	C	D	E	F	G	H	I	J
1	Bradford
2	FeeEarner	April	May	June	Average	FeeEarner	July	August	September	Average
3	AYasmin	72%	106%	100%	93%	AYasmin	96%	79%		88%
4	BKelly					BKelly	121%	80%		101%
5	BVickers		170%	153%	162%	BVickers	108%	120%		114%
Data - %

I need to anchor all the cells (formula's) in columns E & J

Can this be done through a bulk process?

TIA

 

[VoG]

Did you select the range of cells first?

 

[MarkAndrews]

Did you select the range of cells first?

Nope? No one mentioned that

 

[VoG]

Ah, well you have to because this code

Set RNG = Selection.SpecialCells(xlCellTypeFormulas)

expects a selection to have been made.

 

[erik.van.geit]

Did you select the range of cells first?

Nope? No one mentioned that

surely, I did

select range and run code

best regards,
Erik

 

[MarkAndrews]

Did you select the range of cells first?

Nope? No one mentioned that

surely, I did

select range and run code

best regards,
Erik

Doh, I've had a rough week so far

I selected the range & it still didn't work? the formula's are still not absolute?

 

[erik.van.geit]

I asked also

please provide an example: formula + expected result (and the result you get)

it's working nicely for me, so let's find out why not for you
are we talking about "real" formulas ?

 

[MarkAndrews]

Hi Erik

This is my formula

=IF(COUNT(B3:D3)=0,"",AVERAGE(B3:D3))

Columns E & J

I need to make the formula absolute, as per my first post

Here is an example of my data (I have just done the absoluting myself, manually) I hope this give you a better idea of what i am trying to achieve

FE Monthly Analysis.xls
	A	B	C	D	E	F	G	H	I	J
2	FeeEarner	April	May	June	Average	FeeEarner	July	August	September	Average
3	AYasmin	72%	106%	100%	93%	AYasmin	96%	79%	83%	86%
4	BKelly					BKelly	121%	80%	68%	90%
Data - %

 

[erik.van.geit]

works good for me as expected
this is really simple code, I cannot see any reason why it wouldn't work for you

don't think the Excelversion might be a problem
what version are you using ?

are you sure you selected column E and the code did actually run ???
to try out: select a range without formulas and you should get a popup when running