Results 1 to 2 of 2

Thread: Paste data into open coulmn

  1. #1
    VBAX Newbie
    Jun 2019

    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
                        With Sheets("Result")
                        lst = .Range("A" & Rows.Count).End(xlUp).Row + 1
                        .Range("A" & lst).PasteSpecial xlPasteColumnWidths
                        .Range("A" & lst).PasteSpecial xlPasteValues
                         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