Results 1 to 16 of 16

Insert Values only

Threaded View

stockgoblin42 Insert Values only 05-14-2013, 03:22 PM
NeedForExcel Re: Insert Values only 05-14-2013, 03:44 PM
stockgoblin42 Re: Insert Values only 05-14-2013, 05:30 PM
NeedForExcel Re: Insert Values only 05-14-2013, 11:13 PM
HaHoBe Re: Insert Values only 05-15-2013, 12:45 AM
NeedForExcel Re: Insert Values only 05-15-2013, 03:08 PM
Leith Ross Re: Insert Values only 05-15-2013, 03:30 PM
HaHoBe Re: Insert Values only 05-15-2013, 03:42 PM
Leith Ross Re: Insert Values only 05-15-2013, 03:51 PM
stockgoblin42 Re: Insert Values only 05-17-2013, 10:52 AM
HaHoBe Re: Insert Values only 05-17-2013, 01:08 PM
stockgoblin42 Re: Insert Values only 05-17-2013, 01:19 PM
  1. #1
    Forum Contributor stockgoblin42's Avatar
    Join Date
    05-26-2011
    Location
    vancouver, canada
    MS-Off Ver
    Excel 2010
    Posts
    222

    Insert Values only

    Hi,

    Currently I'm using:

    Sheets("Analyzer").Select
              Range("A2:M6").Select
              Selection.copy
              Sheets("Results").Select
              Range("A2").Select
              Selection.Insert Shift:=xlDown
    Is there a faster way to do this that only inserts the values? I do require an insert, not just a paste.
    Last edited by stockgoblin42; 05-14-2013 at 03:27 PM.
    live logic & long prosper

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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