Results 1 to 19 of 19

Thread: Column Autochange?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #13
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    All you have to do is figure out which columns in PasteSheet get copied to columns H:M on 13 Program UX ... and then copy this line

    .Range("M2:M" & LastRow).SpecialCells(xlCellTypeVisible).Copy dst.Range("G6")
    changing the ranges as appropriate.

    I give up trying to squeeze the information out of you.
    Last edited by Aussiebear; 12-12-2024 at 11:35 PM.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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