Hi All,
I've been trying to write an Excel VBA script that goes through each cell and each tab, and pops up a message for each cell that ends with a space:
"Warning: TAB NAME -Sheet 1-, CELL -P5- ENDS WITH A SPACE" for each cell with a space.
The If statement below doesn't work, but that may be because I found a VB approach online that doesn't work in VBA. Not sure anyone can fix the below attempt, or if I'm way off?
(ps: I wouldn't want to automatically delete the spaces, since I need to report the spaces back to the person who made the XLS file.)Please Login or Register to view this content.
Thanks so much,
JMC
Bookmarks