+ Reply to Thread
Results 1 to 5 of 5

Trying to Highlight Data using SendKeys "+{LEFT}"

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    Rochester, Minnesota
    MS-Off Ver
    Excel 2007
    Posts
    80

    Trying to Highlight Data using SendKeys "+{LEFT}"

    Hi Folks,

    I am trying to highlight specific data in one window and bring it to the next by using the following code:

    Please Login or Register  to view this content.
    The Shift+Left to select specific data is failing and I am copying over an entire screen. Is there anway to navigate this, or perhaps an alternative solution to highlighting/selecting data?

    Thanks!

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Trying to Highlight Data using SendKeys "+{LEFT}"

    what program are you copying from?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    06-12-2013
    Location
    Rochester, Minnesota
    MS-Off Ver
    Excel 2007
    Posts
    80

    Re: Trying to Highlight Data using SendKeys "+{LEFT}"

    I believe it is an AS400 user interface.

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Trying to Highlight Data using SendKeys "+{LEFT}"

    I have no experience of AS400-does shift+left work when you do it manually?

  5. #5
    Registered User
    Join Date
    06-12-2013
    Location
    Rochester, Minnesota
    MS-Off Ver
    Excel 2007
    Posts
    80

    Re: Trying to Highlight Data using SendKeys "+{LEFT}"

    Yes it does

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Adding multiple "find" with "left" /"Right"
    By Daniel1 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-22-2014, 04:33 PM
  2. [SOLVED] Expanded and collapsed the rows by toggle "+" or "-" sign on left of the text
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-24-2013, 02:49 PM
  3. Replies: 2
    Last Post: 08-17-2012, 05:10 AM
  4. Applying a "Left" formula to an entire column with heading "ValueCol"
    By aad401 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2012, 04:14 PM
  5. Replies: 5
    Last Post: 06-26-2006, 09:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1