VBA code - query using cell reference for greater than

[swanseaexcel]

Hi all,

Have tried using the following code (extract only):

Please Login or Register  to view this content.

Basically, it doesn't like the cell references for the greater than less than bit - anyone know how to correctly word this query?

Bit new to all this!

Thanks.

[Steffen Thomsen]

Hi,

If you've copied the line in here, then maby it's this part

Please Login or Register  to view this content.

Try inserting a space between & and the rest.
Furthermore, you need to exit string when referencing a cell.

Example

Please Login or Register  to view this content.

[foxguy]

Also put a space in

Please Login or Register  to view this content.

[foxguy]

duplicate post

[swanseaexcel]

Please Login or Register  to view this content.

Thanks for the replies guys. Have tried adding the spaces and playing around with this in general as per foxguy's posts but I just can't seem to get it to work! I think I'm missing something?

Above is an extract of the query when I record a macro in excel but I've tried inserting cell references instead of the absolute numbers.

Apologies is this is a duplicate foxguy - Have I asked the same question before?

[foxguy]

Apologies is this is a duplicate foxguy - Have I asked the same question before?

I was the one that had a duplicate post. My computer really slowed down and I didn't think i had hit "Submit", so I hit it again.

[swanseaexcel]

Ah ok! Any idea on where I'm going wrong with this? Am tearing my hair out as I've tried tweaking plenty of things but I keep getting an error. I know it's only a space or a character that's wrong too!

Thanks!

[Steffen Thomsen]

Please Login or Register  to view this content.

As written in my previous post, you have to exit the strin when referencing the cells and then go into the string again when continuing the query