Highlight LEFT and hit F1. You will see that Left takes 2 arguments. I
omitted the second argument to show the number of cells from left to use

Left(cell.Value = " ")

should be

Left(cell.Value,2) = " "

where the "" contain two spaces.

My typo.

--
Regards,
Tom Ogilvy


"Ricky Pang" wrote:

Hi Tom,
Thank-you for coming to my rescue yet again. When I ran both codes, I
got this same error message: Compile Error: Argument not optional.
While debugging, the [left] is highlighted (which is the 5th line down
of the Remove2LeftBlanks code).

My apologies, I'm unsure what you meant by Do it in place.

I hope to see your reply again.

Much appreciated.

Ricky


*** Sent via Developersdex http://www.developersdex.com ***