Posts by jonny

Re: Button Size as s Cell Size?

Dave Hawley & lasw10, thank you a lot for a good answers.
Nice to learn smth new that may assist in your work.

1. How to make Button Size as a Cell Size?
2. How to freeze the button, or any othe control from seeing its "right click" menu?

Thanks in advance.

Re: "For" loop till end of column??

Hello, Dave.

Thank you a lot for an answer.

How to build the "for" loop that run on column, from first row till end row.
Attached the sample.

Thanks in advance.

Re: Remove "Chr(13)" from a cell

Andy, thanks.

It works!

May I put condition , that in a case of one "enter" do:
Range("a4").Replace vbCrLf , ""
and in a case of two "enters" do:
Range("a4").Replace vbCrLf & vbCrLf, vbCrLf

Thanks

Replace of double "enter" in a cell by one??

How can I replace double "enter" by one??

in Excel: function "clean()" removes all "enters".
in VBA: str = Replace(str, vbCrLf, "") removes all "enters" also

Re: Remove "Chr(13)" from a cell

How can I replace double "enter" by one??

Thanks

Re: Remove "Chr(13)" from a cell

Pangolin, thanks a lot for a prompt response.

It also may be solved by "=CLEAN(A1)". You solution is nice , but does not care for next case (see attachment).

How to remove "Chr(13)" or "enter" from a cell, by VBA code or by a function. Attached a needed example.

I must to remove "enters" and to save column structure of the strings.

Thanks in advance.