Compile Error: Expected expression

**drewship** · 01-14-2016, 12:30 PM

Hello all.
Trying to compare values between cells in row 1 with offset cells in row 3 and get a 'Compile Error: Expected expression' on the colored line. I tried various combinations of () with various errors. How should this be written? Thanks.

Please Login or Register  to view this content.

**AB33** · 01-14-2016, 01:22 PM

Please Login or Register  to view this content.

**drewship** · 01-14-2016, 01:41 PM

Thanks AB33. I copied the code block but now I get Run-Time error 13: Type mismatch on the colored line below. Both MyCell and cellOffset are ranges so I am confused. If cell "D1" is being compared to cell "D3", the offset(2) should do this. The only thing I can think of is that "D1:F1" calculated values based on a "CountIf" formula. Wouldn't .Value get the actual value of the cell?

Please Login or Register  to view this content.

**AB33** · 01-14-2016, 01:55 PM

I knew the code was wrong.

Set cellOffset = All_Data.Offset(2

is a range, so you can not compare(Evaluate) it against a range, but you can against a single cell

If MyCell.Value < cellOffset.Value Then

You can use this line

Please Login or Register  to view this content.

' this is going down

OR

Please Login or Register  to view this content.

**drewship** · 01-14-2016, 02:27 PM

PERFECT!!!!!!! I know enough to understand what I am trying to do logically but it is the details that get me every time.

**drewship** · 01-14-2016, 02:33 PM

Tried to add rep but won't let me until I spread some more around...

Compile Error: Expected expression

LinkBack

Thread Tools

Rate This Thread

Display

Compile Error: Expected expression

Re: Compile Error: Expected expression

Re: Compile Error: Expected expression

Re: Compile Error: Expected expression

Re: Compile Error: Expected expression

Re: Compile Error: Expected expression

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] UDF gives compile error: expected:expression

Compiile error: Expected: expression

VBA error question (Expected expression) Application.Worksheetfunction

[SOLVED] Compile Error: Expected: expression

[SOLVED] Compile Error: Expected Expression, Syntax Error

VBA compilation error : expected expression error

if isna vlookup expected expression error

Bookmarks

Bookmarks

Posting Permissions