Recent content by Class00499

Outstanding!! Thanks for the help

Sub Deletechars() Set myRange = Selection For Each myCell In myRange myCell.Characters(11, 1).Delete Next End Sub This is the latest macro that I found. Is there a way to make this macro work in a specific column and not the other columns?

I need a macro that: Will only work in Column H I don't want the macro to delete data from another cell by accident. Will delete the last letter in the cell(s) selected leaving 10 characters in the cell won't delete beyond the 10 characters I don't want a button or anything like that...