Using "MoveEndWhile"

R

Robin Tucker

When using "MoveEndWhile", is it possible to use carriage returns in the
CSet:= parameter? I would like to move the end of a range while I am
encountering spaces or newlines.
 
J

Jay Freedman

Robin said:
When using "MoveEndWhile", is it possible to use carriage returns in
the CSet:= parameter? I would like to move the end of a range while
I am encountering spaces or newlines.
Click to expand...

Hi Robin,

Yes, use something like CSet:=" " & vbCr for the parameter. There are also
vbTab and vbVerticalTab (the manual line break you get from Shift+Enter).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

table column name with newline, cannot select with string 1
Pasting a web hyperlink into text 1
VBA word change keys 0
Request help determining line length and end of line carriage returnsthrough document 0
Word macro that can call cells out of Excel for a find and replace 0
Wrapping and Anchors 0
Problems with document variables in .docx file shared between Word 7
White space above heading inconsistently applied 1

Top