Not as easy as I had hoped. If I'm forced to insert column "A:A" I can, but am hoping to use offset rather than a firm address.
Aa aways, TIA
Ron
Range ws_2Users1_LogOnID is in cell A1.
Aa aways, TIA
Ron
Range ws_2Users1_LogOnID is in cell A1.
VBA Code:
' Range("ws_2Users1_LogOnID").Offset(, -1).EntireColumn.Insert ' nothing happens
Range("ws_2Users1_LogOnID").EntireColumn.Insert 'this works
Range("wws_2Users1_LogOnID").Offset(, -1).Name = "ws_2Users1_IsClosed"
Range("ws_2Users1_IsClosed").Value = "Closed Account"
Range("ws_2Users1_IsClosed").Offset(1, 0).Resize(LastRow).Name = "ws_2Users1_RngIsClosed"