Paste only the first seven digits

[nipthedog]

Hi, I have a line of code that copies several cells and pastes the values in another WB. One of the cells being copied ("A12"), I only need the first 7 digits. What would work here, I've tried several variations to no avail. Thanks, Chris

Please Login or Register  to view this content.

[danielexcelvba]

Try replacing "Range("A12").Text" with Left(Range("A12").Text, 7)

[nipthedog]

I managed to get this one, thanks until the next time

Please Login or Register  to view this content.

[mehmetcik]

Please Login or Register  to view this content.

[nipthedog]

Try replacing "Range("A12").Text" with Left(Range("A12").Text, 7)

Hi, thanks for your answer, I got it myself at the same time! Rep added!

[danielexcelvba]

Thanks for the rep!