Syntax Error Finding Last Row

[jo15765]

I am attempting to find the last row with data in column G and clear everything after a . My syntax will clear fine if I hardcode cells to search, but since adding in the last cell it throws an error of Invalid Syntax. What do I need to change to make this valid syntax?

Please Login or Register  to view this content.

[kev_]

Try:

Please Login or Register  to view this content.

instead of:

Please Login or Register  to view this content.

So remove the 2nd colon ( : ) and insert the ampersand symbol ( & ) after the quotation marks

[jo15765]

Excellent! Thank you!