+ Reply to Thread
Results 1 to 2 of 2

What is wrong with code?

  1. #1
    Registered User
    Join Date
    07-20-2023
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    1

    What is wrong with code?

    Hello
    Could someone please review the code and tell me what's wrong? Macro runs successfully and copies the data from InputData sheet into Sheet1 except 2 columns.
    Data in column P and Q in InputData sheet are Dates (with date formatting). VBA is not pasting the data from these two column in column T and U in Sheet1. After macro runs successfully, column T and U are blank. One thing to note, after macro runs, cell T2 and U2 in Sheet1 is having Date formatting whereas remaining cells are having Custom formatting.

    Please Login or Register  to view this content.
    I have tried different method to make it work like below, but nothing seems to work so far.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: What is wrong with code?

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. [SOLVED] Please, help me with the code for Similarity Factor Calc. My code gives wrong number.
    By Invictus1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-22-2015, 09:52 PM
  2. what is wrong with this code- error from vba code
    By punna111 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2013, 03:14 PM
  3. Code for email alerts from excel isn't working, wrong code possibly?
    By jessthorogood in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2012, 01:45 AM
  4. Wrong line of code banned me out and can't access vba code...
    By albertc in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-14-2012, 02:41 PM
  5. What's wrong with my code ?
    By Don Guillett in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 07:05 PM
  6. [SOLVED] What's wrong with my code ?
    By christophe meresse in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. What is wrong with my code???
    By sand in forum Excel General
    Replies: 1
    Last Post: 06-27-2005, 01:05 PM

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