+ Reply to Thread
Results 1 to 3 of 3

Copy and paste values all cells w/o select?

  1. 10-28-2017, 08:14 PM #1
    franklin_m
    franklin_m is offline
    Registered User
    Join Date
    11-25-2011
    Location
    Alaska
    MS-Off Ver
    Excel 2003
    Posts
    42

    Copy and paste values all cells w/o select?

    There's probably a simple answer to this, but I'm stumped. How do I perform the following w/o using "select" or "activate" ?

    Please Login or Register  to view this content.
    Thanks!
    Reply With QuoteRegister To Reply
  2. 10-29-2017, 02:27 AM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Copy and paste values all cells w/o select?

    How I would do it:
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 10-29-2017, 09:17 AM #3
    franklin_m
    franklin_m is offline
    Registered User
    Join Date
    11-25-2011
    Location
    Alaska
    MS-Off Ver
    Excel 2003
    Posts
    42

    Re: Copy and paste values all cells w/o select?

    That works! Awesome...thank you. Also learned a new technique, so thanks for that as well.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Select, Copy, and Paste cells containing certain phrase
    By excelcoolbro777 in forum Excel General
    Replies: 8
    Last Post: 05-31-2016, 06:05 PM
  2. Select range of cells to copy/paste values based on contents of a different cell
    By gastank10 in forum Excel General
    Replies: 2
    Last Post: 02-06-2016, 10:19 AM
  3. [SOLVED] Copy values and paste as values WITHOUT SELECT
    By brainzlp in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-29-2015, 07:24 AM
  4. Excel Macro to select the each values from drop down list and copy-paste the values
    By Chito in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2014, 12:52 AM
  5. [SOLVED] VBA: select a row of cells and copy paste value
    By DavidRoger in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2014, 12:33 AM
  6. VBA to copy and paste select cells
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-22-2013, 01:13 PM
  7. find, select, copy paste values
    By gsrai31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2011, 01:59 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1