Results 1 to 10 of 31

Thread: Copy Row To Another Sheet On Change Of Value/Update Value To Another Sheet On Change

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #20
    Moderator
    Join Date
    Jul 2012
    Posts
    156
    Rep Power
    14
    I've made some changes in the event-macros both on sheets Failed and Missing devices so it's easier to add or remove names that need to be checked instead of all those 'OR' arguments.
    About exporting to PDF you could set a printarea in advance and then in ExportAsFixedFormat set the property IgnorePrintAreas to False. I haven't tested that yet but i presume it won't export outside that set area.
    Attached Files Attached Files

Similar Threads

  1. Replies: 10
    Last Post: 06-20-2013, 12:21 AM
  2. Replies: 8
    Last Post: 04-16-2013, 02:04 PM
  3. Change Display Range Based On Change of Dropdown Values
    By rich_cirillo in forum Excel Help
    Replies: 2
    Last Post: 03-29-2013, 04:58 AM
  4. Replies: 2
    Last Post: 12-26-2012, 08:31 AM
  5. Copy Row To A New Sheet If A Value Found In Adjacent Column
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 08-17-2012, 05:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •