Yuris thanks very much! For some reason in the following, the last range select
selects a13:m229, the full used range of the spreadsheet, but row 13
and below. How can I get it to select only b13:b229??
STeve
With o.Application
.Range("B13").Select
.ActiveCell.FormulaR1C1 = "=MID(RC[-1],1,10)"
.Range("B13").Select
.Selection.Copy
.Range("A1").Select
wait
.Range("B13:B229").Select && the last range select
EndWith
wait