Remove extra line when pasting copied cell into database

[Mike TheSpike]

Hi All,

I need help guys, I want to eliminate extra step by not using backspace just to remove extra line(space) every time I paste a copied cell from excel into database or like in notepad just for example below.

Many Thanks,
Mike

 

[Zot]

How do you copy right now?

 

[Mike TheSpike]

How do you copy right now?

Hi Zot

here's the macro for the copy.

Range("D2").Select
Selection.copy

Thanks again,
Mike

 

[Zot]

There is linefeed or line break there to be removed, I'm just guessing. the character probably Chr(10)

I guess you are using macro recorder to write code. It is not efficient way but will work. Avoid if possible using Select.

Say I want to copy D2 to E7. Then use Replace to remove the line break

Range("D2").Copy Range("E7")
Range("E7") = Replace(Range("E7"), Chr(10), "")

 

[Mike TheSpike]

There is linefeed or line break there to be removed, I'm just guessing. the character probably Chr(10)

I guess you are using macro recorder to write code. It is not efficient way but will work. Avoid if possible using Select.

Say I want to copy D2 to E7. Then use Replace to remove the line break

Range("D2").Copy Range("E7")
Range("E7") = Replace(Range("E7"), Chr(10), "")

Hi Zot
I tried your code however i need to copy again the E7 which should be pasted into the database or like in notepad wherein there is always an extra line break(space) after pasting the copied cell.
Thanks for the feedback of the code using Select