•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Avoiding Green triangle cells in VBA?
Hello,
I'm attempting to write a macro to automatically generate remittance based on a file I receive from our client. The spreadsheet comes over with the classic green triangles, indicating I need to "convert to a number". Usually I do this manually via the mouse as so:
How do I get around this in VBA? I've attempted the below which didn't work:
Range("A2:V") = Range("A2:V").Value
Any other ideas for me?
[link] [comments]
Want to read more?
Check out the full article on the original site