Left fuction in VBA code.

[maacmaac]

I am trying to use the Left function in my VBA code but continue to receive run time error 1004 - Method 'range' of object '_global' failed. Not sure if the error originates for code being written incorrectly or if the left function is not available in VBA. I am basically trying to take the first 9-characters for each cell in column K and copy the values to column G. Thank you.

Please Login or Register  to view this content.

[broro183]

hi,

Here are (edit: "two"! not "too" - duh me! end edit) untested code snippets that may help...

Please Login or Register  to view this content.

hth
Rob

[maacmaac]

Thanks. Both codes work. I ended up using the 2nd solution as it runs faster than the 1st.

[broro183]

Thanks for the feedback & marking the post as solved - I'm pleased I could help :-)

Rob