Posted to microsoft.public.excel.misc

Jim May

external usenet poster

Posts: 477

syntax error - help

Worksheets("Cost Analysis").Activate
Set UdRng = ActiveSheet.Range("F10:F38")
UdRng.Formula = "=IF(AND(A100, H100),"EQ","")" << occuring here
ActiveSheet.Range("A9:G38").Select
Selection.AutoFilter

Help appreciated

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
Lookup : Syntax Error	Steve_n_KC	Excel Worksheet Functions	0	June 14th 07 07:59 PM
MS Query import from Excel - Syntax Error	EstherJ	Excel Discussion (Misc queries)	1	April 24th 06 09:44 AM
what is a syntax error in microsoft acess	Syntax Error	Charts and Charting in Excel	0	July 28th 05 05:56 AM
Formula syntax error - chinese and gibberish	Joshua Fandango	Excel Discussion (Misc queries)	3	March 29th 05 01:27 PM
Vlookup Syntax Error	YV	New Users to Excel	9	December 23rd 04 05:28 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us