strange changing Vlookup formulas.

[BJS1002]

Hi,

I'm hoping you can help with these issues.
1.
I have a workbook where I import data from other workbooks into various hidden sheets.
I then have one master sheet that links them all together using vlookup.
My problem is when I import the workbooks my Vlookup formula change the look up range.

2.
I am getting a privacy warning.
"This document contains macros, ActiveX Controls, XML expansion pack information or Web components."
I checked the Macro settings but it is all greyed out.

Thanks in Advance

 

[oldbrewer]

show us your lookup formula please

 

[BJS1002]

Hi oldbrewer

=IFERROR(VLOOKUP(A2,AEDB_COPY!$A:$EH,32,FALSE),0)

It changed to (Change in bold) =IFERROR(VLOOKUP(A2,AEDB_COPY!$E:$EH,32,FALSE),0)

 

[oldbrewer]

if it is an error then 0
but what if it is not an error

 

[BJS1002]

I found my problem. I was importing to the worksheet the Vlookup was pointing to and as part of my code I was inserting a column in "A", so to work around that I will change the way I import data.

so I now have a new problem. When I change my code to paste from A1 to B1 I get an error. my code is:

Workbooks.Open Filename:= 'server file
ActiveWorkbook.SaveAs Filename:="C:\TEMPLATES\import.csv"
Selection.AutoFilter
Selection.AutoFilter Field:=10, Criteria1:=Array( _
"Access Cap", Operator:=xlFilterValues

Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
Workbooks("GF Tracker Master.xlsm").Activate
Worksheets("import").Range("B1").PasteSpecial xlPasteValues


Any help is greatly appreciated.

 

[oldbrewer]

why not just pastein the last line of your code with cells(2,2).select and then the code for a normal paste
(you have already copied the range ready for pasting)