+ Reply to Thread
Results 1 to 2 of 2

Macro paste problem & date selection

  1. #1
    Registered User
    Join Date
    02-21-2009
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Macro paste problem & date selection

    Hi...
    i have been wring a macro to copy n past a set of value from 1 file to another...however...when come to paste it will got problem on the paste file... below is the script:

    Please Login or Register  to view this content.
    when i run through n come to paste "selection.Paste" it will come out an error "Object doesn't support this property or method"...
    i really duno what is the problem...can any1 help me?


    Another thins is...i would like to do a date selection from a list of date....lets say in the raw data file the date will be range form 2006/03/09 09:55:56 to 2008/12/03 02:04:43...i would like to select the range of date n time i wan...like 2008/11/03 00:00:00 to 2008/12/03 00:00:00, how can i write my macro to select the range?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    Win10/MSO2016
    Posts
    13,000

    Re: Macro paste problem & date selection

    Try Activesheet.Paste instead of Selection.Paste
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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