remy988
12-13-2012, 11:01 AM
is there a shorter way to write this
cell.Offset(0, 6).NumberFormat = "@"
cell.Offset(0, 7).NumberFormat = "@"
cell.Offset(0, 8).NumberFormat = "@"
cell.Offset(0, 9).NumberFormat = "@"
cell.Offset(0, 10).NumberFormat = "@"
cell.Offset(0, 11).NumberFormat = "@"
thanks
rem
cell.Offset(0, 6).NumberFormat = "@"
cell.Offset(0, 7).NumberFormat = "@"
cell.Offset(0, 8).NumberFormat = "@"
cell.Offset(0, 9).NumberFormat = "@"
cell.Offset(0, 10).NumberFormat = "@"
cell.Offset(0, 11).NumberFormat = "@"
thanks
rem