nel1215 Posted May 31, 2007 Report Share Posted May 31, 2007 I have loads of data and over 150 work sheets. Is it possible to automate the Control-Shift Arrow button? I have 5 columns and about 600-1000 lines on each sheet. I am trying to automate the highlight copy and paste to another place via Macro Express. I tried the Text Type, "CTRLD, SHFTD, Right Arrow" ut it freezes up my system all the time. Is there another way of doing this? Any help would be appreciated. Thanks! Quote Link to comment Share on other sites More sharing options...
Cory Posted June 1, 2007 Report Share Posted June 1, 2007 I don't have an answer for what you are trying to do but I would suggest that this is not best way to select a range. Personally I use Excel's F5 command instead. Basically you do the F5 then spec the range like A1:G456 and enter. It's super easy. Also I have written macros that will add logic to this so that it will note the users current position from the status bar and then create a range that is X over and Y down from that position. That's all really easy. Also I don’t know if you know this or not but all the copyclips from Excel and most Office applications appear as tab separated files when read into ME. From there it’s super simple to parse and manipulate data internally in ME instead of arrowing all over the place in Excel and running into problems like what you mention. Quote Link to comment Share on other sites More sharing options...
nel1215 Posted June 1, 2007 Author Report Share Posted June 1, 2007 Thank you for your reply. I have gotten everything to work now. I forgot a very simple step... I forgot to do ctrl u and shift u... That step locked up my computer each time... 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.