Hello Excel Forum Community,
I am in need of some assistance making a macro that will loop through columns A2 through N2 to make sure each cell doesn't exceed the max characters.
To make more sense, I have been using excel cell validation tool to limit a range of cells from having a certain amount of characters. For example in column A, the max length for each cell is 50 characters. If someone typed in anything that exceeds fifty characters then excel prompts an error message. This currently works fine however, when I am copying bulk data from another worksheet and many of the copied data have more then 50 characters then the data validation doesn't not work anymore. This is why I need a macro.
To further complicate things, I want it to highlight each cell that is yellow and pompt a message when it is finished validating.
Attached is a sample sheet:
Max Lengths for columns
A - 50
B - 3000
C -100
D - 3000
E - 30
F - 50
G - 300
H - ignore (skip, doesn't matter)
I - 100
J - 3000
K - 30
L - ignore (skip, doesn't matter)
M - 20
N - ignore (skip, doesn't matter)
Thanks!
Bookmarks