Hi I got it
the mistake was in parenthesis
[VBA] .Cells(i, "A") = Left(Range("A" & i).Value, Len(.Cells(i, "a")) - 2)
[/VBA]
Hi I got it
the mistake was in parenthesis
[VBA] .Cells(i, "A") = Left(Range("A" & i).Value, Len(.Cells(i, "a")) - 2)
[/VBA]
Always Mark your Thread as Solved the moment u got acceptable reply (located under Thread tools)
Practice this & save time of others in thinking for unsolved thread
Posting Permissions
Reply With Quote