Try changing both instances of:
to:WkSht.Cells(r, c).Text
Code in post 17 revised.WkSht.Cells(r, c).Value
Try changing both instances of:
to:WkSht.Cells(r, c).Text
Code in post 17 revised.WkSht.Cells(r, c).Value
Last edited by Aussiebear; 04-25-2023 at 10:25 PM. Reason: Added code tags
Cheers
Paul Edstein
[Fmr MS MVP - Word]