Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
exclude a column
After copy paste my excel crashes....
I've worked out the solution another way. Thanks for your comment. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add numbers in a column, but exclude percentages in the same colum | Excel Worksheet Functions | |||
Max Value in a column exclude selection - Excel VBA | Excel Discussion (Misc queries) | |||
I want to sum a column and exclude those ending with cr | Excel Worksheet Functions | |||
Need a formula that sums a column but could exclude some cells | Excel Worksheet Functions | |||
Exclude a column from a table calculation | Excel Programming |