+ Reply to Thread
Results 1 to 2 of 2

Need code to unhide a row when data is transferred between sheet by macro.

  1. #1
    Registered User
    Join Date
    04-20-2014
    Location
    London
    MS-Off Ver
    Windows Excel 2010
    Posts
    79

    Need code to unhide a row when data is transferred between sheet by macro.

    Hi guys

    I have the following code, it moves a row of data to another sheet based on a certain in the status column.

    When the row is copied over to the other sheet, I would like when it pastes the data in to UNHIDE the row. This is due to the fact that at the current time all of the sheets have rows that are hidden unless there is data in them.

    Is it possible you could add the unhide feature?

    If there is also a way to tidy up my code that would be great!

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    04-20-2014
    Location
    London
    MS-Off Ver
    Windows Excel 2010
    Posts
    79

    Re: Need code to unhide a row when data is transferred between sheet by macro.

    Also the code seems to paste data in and move the position of the data to the LEFT of the cell which is annoying. Is this due to the way its being pasted? I just want the value to be pasted into the cell so none of the formatting (text position) is changed.

+ 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. Prevent duplicates in combo box but not in the originally transferred sheet.
    By Terhab in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2013, 11:51 AM
  2. Replies: 2
    Last Post: 10-09-2012, 04:40 PM
  3. Replies: 15
    Last Post: 09-25-2012, 10:22 AM
  4. Need code to unhide next row without data
    By Mike Church in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2012, 06:00 PM
  5. transferred DATA TO ANOTHER SHEET
    By hesham63 in forum Excel General
    Replies: 0
    Last Post: 06-22-2010, 09:26 AM

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