macro express blanks

[yurdalsldrk]

Hi I want to stop the empty row in the macro express de excel thanks 

[terrypin]

You should either provide  more detail (with a screenshot or script text), or you should do as I suggested in my reply to you a week ago in your post ‘Copy error’.

[amonaghan]

This should work, although it is a bit slow. If anyone knows of a quicker way, please let me know?

Shamelessly stolen from here :- https://www.macros.com/faq/1.79.html

Repeat Until %cClipboardString% Equals ""
  Text Type (Simulate Keystrokes): <ARROW DOWN>
  Clipboard Copy
  Variable Set String %cClipboardString% from the clipboard contents
  Variable Modify String %cClipboardString%: Trim
End Repeat

 

<VARIABLE SET STRING Option="\x00" Destination="%cClipboardString%" NoEmbeddedVars="FALSE" _ENABLED="FALSE"/>
<REPEAT UNTIL Variable="%cClipboardString%" Condition="\x00"/>
<TEXT TYPE Action="0" Text="<ARROW DOWN>"/>
<CLIPBOARD COPY/>
<VARIABLE SET STRING Option="\x02" Destination="%cClipboardString%" NoEmbeddedVars="FALSE"/>
<VARIABLE MODIFY STRING Option="\x00" Destination="%cClipboardString%"/>
<END REPEAT/>

Alan