Replace range name in a formula for range

[iosu]

Hi there

I'm trying to change a range in a formula, from

=COUNTA(range_name)

To

=COUNTA(D2:D10)

Any ideas on how to do this? My macro first named some ranges but then I need to have just the ranges.

THX!!

 

[texasalynn]

if there are range_names that match the area of the range then Excel would change the range address to that range name

 

[iosu]

...and any solution deleting the range name? Or maybe something that tells me wich range is it - that will do...