I want a offset macro that will go back -11 to -18 colums down 6000 rows and will copy/paste/format/value back into there original cells but losing all there formulas , so really just wanting to get rid of the formulas, the first line does work but not the rest
Cells(1, Cells(1, 256).End(xlToLeft).Column + 1).Select
With ActiveCell.Offset(-11, 0).Resize(6000, 7)
.Value = .Value
End With
End Sub
Thanks for your help ..Bob
Cells(1, Cells(1, 256).End(xlToLeft).Column + 1).Select
With ActiveCell.Offset(-11, 0).Resize(6000, 7)
.Value = .Value
End With
End Sub
Thanks for your help ..Bob