exclude a column
 

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)

Bernd

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

exclude a column
 

After copy paste my excel crashes....

I've worked out the solution another way.

Thanks for your comment.

exclude a column
 

Hi Bernd,

After copy paste my excel crashes....

Your reference to a copy / paste operation is not clear.

Howver there is nothing in my suggested code:

Dim Rng As Range

Set Rng = Range("B5").Resize(1, Columns.Count - 1)

MsgBox Rng.Address(0, 0)

which I would expect to provoke a crash.


---
Regards,
Norman