Reference Cell - Active cell usage

[Ram Vepuri]

Dear Gurus,

Being a newbie, would request the experts to provide your inputs.
I've recorded a macro using relative reference cell option, in which I've opted to deleted the space and special characters. But during recording my sample file has 18 rows but the other sheets data is not dynamic.

If I run the existing macro it consider to update only till 12 rows and next, it does not work.
Can you please check and provide the reference code to select the range of data in same column.

Thanks

 

[Belleke]

Where is the existing macro?
Does not work in xlsx

 

[Ram Vepuri]

excuse me... here is macro enabled file... use TEST macro