VBA to Split Workbook: No Longer Converting Formula Results to Values

Ah, OK - well, it never was the leftmost tab, so I wonder why it worked before?

Not sure Is the code creating anew workbook? If so and if that tab isn't the first it obviously won't convert Row 2 to 4 to values (it will on the first tab in the new workbook )

Where would I put the two lines you have given me to incorporate them into the current macro?

Replace (or comment out) this line...

.Sheets(1).Rows("2:4").Value = .Sheets(1).Rows("2:4").Value

...with this:

.Sheets(1).Range("A1,B2:U4,E94:U104").Value = .Sheets(1).Range("A1,B2:U4,E94:U104").Value

Robert