Results 1 to 3 of 3

What's wrong with this Macro to Copy and Paste?

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    Farmington, New Mexico
    MS-Off Ver
    Excel 2003
    Posts
    2

    What's wrong with this Macro to Copy and Paste?

    Sub Macro1()
    
        Range("J6:J31").Select
        Application.Run "bob"
        Selection.Copy
        Range("K6").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
    End Sub
    Last edited by davesexcel; 01-11-2023 at 02:56 PM. Reason: code tags required for vba code

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Basic copy and paste is producing wrong result.
    By Annelie in forum Excel General
    Replies: 7
    Last Post: 06-02-2019, 09:53 PM
  2. [SOLVED] Copy paste gives wrong cell
    By alisachsf in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2017, 06:55 PM
  3. [SOLVED] VBA copy/paste pasting to wrong row
    By LITOA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-27-2016, 01:04 AM
  4. [SOLVED] It sets date format wrong when copy and paste
    By zanshin777 in forum Excel General
    Replies: 18
    Last Post: 01-16-2016, 08:16 AM
  5. Copy and paste under the last used row - what's wrong with this code?
    By luke1908 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2014, 04:10 PM
  6. [SOLVED] Copy/paste button code work wrong
    By mirenoba in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-05-2013, 05:52 AM
  7. Copy-paste from csv to xls macro > wrong date format
    By Gero in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2009, 06:12 AM

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