VBA VLOOKUP with loop using a locked for editing file for data

[snewell]

I have attached a file that has partial code in the VBA editor

I want to loop thru Cells A17 thru A34 and return the V lookup results in cells H17 thru H34

The code in the worksheet is returning the value for H17 correctly, I just need to complete the loop

When the data file workbook is open I get a message that says the file is locked for editing. I think this may be causing issues when I try and run the code

Thanks


Steve

[dflak]

Is the sole purpose of the VB code to duplicate the VLOOOKUP formula form row 17 down as many rows as you have? If so, then investigate converting the range of data into an Excel Table. When you copy and paste data into a spreadsheet, one of the things a table does is copies the formula down automatically for you. Here's a link to an introduction to tables: http://www.utteraccess.com/wiki/inde...ables_in_Excel

In this case, you'll have to do a bit of work on the headers. You have the headers in two rows. You will have to combine them into one row. With wrap, they should still look the same on the spreadsheet. Then highlight the table area (first row and column of header and data to last row and column of data) and click on Format as Table.