View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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