PENGUIN
10-02-2014, 05:31 AM
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).
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).