Pistolade

Junior Member

Posts: 20

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

Else;
End Sub

Thanks,
Pistolade

Last edited by Pistolade : February 6th 14 at 08:40 PM Reason: Added Detail

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CONDITIONAL STATEMENT	RYNNER	Excel Programming	4	February 21st 09 09:15 AM
conditional statement; is that what i need to use?	vasi	New Users to Excel	10	October 20th 08 07:12 PM
Help with this conditional IF statement	C-Dawg	Excel Discussion (Misc queries)	3	May 15th 06 06:01 PM
Conditional If statement	Dan	Excel Worksheet Functions	0	March 26th 06 11:46 PM
Conditional IF statement	Rick[_21_]	Excel Programming	2	October 29th 03 04:52 PM

All times are GMT +1. The time now is 02:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us