| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check values in each column
Hi
I want to check the value of row 2 in each column and if it = "#N/A" then delete the column. I have got this far but it doesn't wuite work. Can anyone help? For iColumn = 1 To 256 If Cells(2, iColumn).Value = "#N/A" Then Columns(iColumn).EntireColumn.Delete Next iColumn Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check for numeric values in a column | Excel Programming | |||
| Loop through column(s) to check values, perform action based on check | Excel Programming | |||
| Check if all values in a column is identical | Excel Programming | |||
| How to check for duplicate values within a column | Excel Programming | |||
| check value in cells against all values in a column | Excel Programming | |||
Threaded Mode
