Hey guys,
I'm looking for a macro (to attach to a button) which would copy the formula values (AHT in U:MM:SS) in cells AB:AD to cells AE:AG and convert these values into plain text.
The rows can go up 100k lines .... having this funcitonallity would save me loads of time!
AB:AD might also contain empty/blanc results which may also be copied as an empty cell, however i do not forsee any problems with that.
Would be awesome if you guys have an idea on how to tackle this!
grts. Swiemel
I'm looking for a macro (to attach to a button) which would copy the formula values (AHT in U:MM:SS) in cells AB:AD to cells AE:AG and convert these values into plain text.
The rows can go up 100k lines .... having this funcitonallity would save me loads of time!
AB:AD might also contain empty/blanc results which may also be copied as an empty cell, however i do not forsee any problems with that.
Would be awesome if you guys have an idea on how to tackle this!
grts. Swiemel
