Good morning Westconn1.
I modified my code with yours. During the execution, at the tail end I got a "Run-Time error: 1004 - Application-defined or object-defined error" on this line of code:
Code:
.RowHeight = .RowHeight * Len(xlWksht.Range("A" & a).text) / w
Do you think we should do the calculation separately before asigning it to .Rowheight?
Thanks.
GiftX