Consulting

Results 1 to 2 of 2

Thread: Paste data into open coulmn

  1. #1
    VBAX Newbie
    Joined
    Jun 2019
    Posts
    1
    Location

    Paste data into open coulmn

    good day

    i have the following code to paste data in the first open line in a different sheet and it works great

    Dim lst As Long
                        WSIM.Range("P2:T2").Copy
                        With Sheets("Result")
                        lst = .Range("A" & Rows.Count).End(xlUp).Row + 1
                        .Range("A" & lst).PasteSpecial xlPasteColumnWidths
                        .Range("A" & lst).PasteSpecial xlPasteValues
                        WSIM.Range("P2:T2").Clear
                         End With

    how can this code be changed to rather paste the data in the first open column in the other sheet

  2. #2
    2 things to note, first you have posted this in the MS Access section, hence you're probably not getting any views for from anyone that knows much about XL! Secondly your question is a little bit confusing? It might pay to have a think about what you want and repost it in the correct section.

Posting Permissions

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