+ Reply to Thread
Results 1 to 3 of 3

Pasting array starting in a specific range

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Ottawa, Ontario
    MS-Off Ver
    Excel 2013
    Posts
    104

    Pasting array starting in a specific range

    Hello,

    I am having trouble modifying part of a macro I found. The macro use internet explorer to download all HTML tables found on a specific website. It stores the tables information it in an array and then paste that array starting at the last row found in column A. I would like instead to start pasting the array in A2. I tried playing around with the code such as removing the end(xlUP) but without success; I also try Application.Transpose but no success there as well. FYI the array will vary in size depending on the website. Here is the code I am having trouble with, thank you for your time!

    With ActiveSheet.Cells(1, 1).Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
            .resize(UBound(myarray), UBound(myarray, 2)).value = myarray
        End With
    ‘Source: https://www.ozgrid.com/forum/forum/other-software-applications/excel-and-web-browsers-help/131683-extracting-data-from-a-grid-on-webpage

  2. #2
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    Re: Pasting array starting in a specific range

    try
    With ActiveSheet.Cells(2, 1)

  3. #3
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Ottawa, Ontario
    MS-Off Ver
    Excel 2013
    Posts
    104

    Re: Pasting array starting in a specific range

    Yeah working... easier than I thought, should have thought about that myself Thanks for your quick response!

+ 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. [SOLVED] Auto Pasting Excel Range into Specific Slides in Powerpoint (macro/vba)
    By K_N in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2018, 11:18 AM
  2. Dynamic range starting from a specific cell in the column
    By saaadi1616 in forum Excel General
    Replies: 4
    Last Post: 05-22-2017, 04:36 AM
  3. Copying a specific range and then pasting into another worksheet
    By FROGMAN59 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-12-2015, 05:38 PM
  4. sumproduct of a number array and a text array starting with 2 numbers
    By Bishonen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-21-2013, 11:48 AM
  5. HELP with copying/pasting specific range into different workbook
    By wojizzle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2012, 08:29 AM
  6. Replies: 3
    Last Post: 08-19-2005, 09:05 AM
  7. Pasting an array into a range
    By Tony in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-06-2005, 09:06 PM

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