Mindy79 Posted April 17, 2012 Report Share Posted April 17, 2012 I have excel daa that i copy and paste to my work sofware. My question is how to stop ME run when it get to empty cell in excel. A 1. Abcde 2. Dkeffd 3. I need Macro to stop running as soon as it get to the empty cell(row 3). I try if variable <> null but it doesnt work. Please help! Thank You Quote Link to comment Share on other sites More sharing options...
Samrae Posted April 18, 2012 Report Share Posted April 18, 2012 Excel has a habit of adding CR, LF characters when a cell is copied to or from the clipboard. You could try this: Variable Modify String: Strip CR/LF from %T1% If Variable %T1% = "" Change %T1% to the variable name you are using. Quote Link to comment Share on other sites More sharing options...
Mindy79 Posted April 18, 2012 Author Report Share Posted April 18, 2012 It work... Thank you for your help! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.