exclude a column

[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)

Bernd

 

[Norman Jones]

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
'<<=============

 

[bernd]

After copy paste my excel crashes....

I've worked out the solution another way.

Thanks for your comment.

 

[Norman Jones]

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:

which I would expect to provoke a crash.