Select last cell with the data in the column/range of cells - only visible datas

[PENGUIN]

Hi,
I have used the following macro: www excel-easy.com/vba/examples/from-active-cell-to-last-entry.html
what does works however this macro still select 'empty' cells that contains formula showing "" (blank) if false.
How can I programe this to select only 'visible' datas?

Test file attached: starting with A1 going down I wish to select only numbers we can actually see, not the formulas cells underneath.
I will have to change the range a lot as weel (instead having A1 I may need to have E1:N40 etc).

[D_Marcel]

PENGUIN,

Can you please send a sample? The file wasn't attached.

Regards,

Douglas