| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional If/Else statement
What I need Is a bit of code that checks Table 338 Column 6/F/"LAB PRICE(NC)" for "#VALUE!", and if that text is found to run this;
Code:
ActiveSheet.ListObjects("Table338").Range.AutoFilter Field:=6, Criteria1:="=#VALUE!", Operator:=xlFilterValues
Range("A2", Range("A2").SpecialCells(xlCellTypeLastCell).Offset(0, -4)).Select
Selection.Copy
Windows("DeleteAlso.xlsx").Activate
Range("A3").End(xlDown).Offset(-1).Select
ActiveSheet.Paste
End Sub Thanks, Pistolade Last edited by Pistolade : February 6th 14 at 08:40 PM Reason: Added Detail |
|
#2
|
|||
|
|||
|
Bump.
Anyone figure this out yet? |
|
#3
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONDITIONAL STATEMENT | Excel Programming | |||
| conditional statement; is that what i need to use? | New Users to Excel | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Conditional If statement | Excel Worksheet Functions | |||
| Conditional IF statement | Excel Programming | |||
Linear Mode
