exclude a column
Hi Bernd,
'-----------------
Doe someone know how to select an entire row but it should exclude the
cel in that row of column A?
(the application first goes to a reference and then inserts an entire
new row, but the cel in row A may never be edited)
'-----------------
Perhaps try something like:
'=============
Public Sub Tester()
Dim Rng As Range
Set Rng = Range("B5").Resize(1, Columns.Count - 1)
MsgBox Rng.Address(0, 0)
End Sub
'<<=============
---
Regards,
Norman
|