+ Reply to Thread
Results 1 to 2 of 2

VBA Code Copy Non Blank Cell After Return of Formula Paste Row In New Worksheet And Sort

  1. #1
    Registered User
    Join Date
    07-11-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    91

    VBA Code Copy Non Blank Cell After Return of Formula Paste Row In New Worksheet And Sort

    Hi,

    I have a formula in sheet Email that could either return blank or has a value. Range of cells are from T:AE depends and number of rows depends. Then i need to copy those non blanks cells to "screenshot" sheet which already contain the headers from email. so i'll be pasting it to cell a2. then i would sort Column L to descending. My problem is that when i run the code, the whole row moves to say L43 instead to the cell under the headers

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: VBA Code Copy Non Blank Cell After Return of Formula Paste Row In New Worksheet And So

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ 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