I have searched my books and the net to find out if there is a formulae collection in Excel.
I feel there must be but cannot find any info.
I have some code that performs a Selection.SpecialCells(xlCellTypeFormulas, 23).Select but if there are no formulae an error occurs. I have put an on error condition in place to avoid the problem but I think it would be cleaner if I could establish whether there are any formulae present before launching into my logic.
Any ideas would be welcome.
Thanks
Regards
Chris Bezant
I feel there must be but cannot find any info.
I have some code that performs a Selection.SpecialCells(xlCellTypeFormulas, 23).Select but if there are no formulae an error occurs. I have put an on error condition in place to avoid the problem but I think it would be cleaner if I could establish whether there are any formulae present before launching into my logic.
Any ideas would be welcome.
Thanks
Regards
Chris Bezant