Method 'Range' of object '_Global' failed. error in excel-vba

Hi All,
First of all thanks in advance for your time to read and reply for this.

I am tring to open a file thru vba macro where as path and the file name are refered from 2 different cells
For Example
Cell A2 is with Whole file Path and B Column is with multiple FIle names where as I i tried the below code and it bring "Method 'Range' of object '_Global' failed. error in excel-vba" Error Code
Please help

x = Range("b" & i).Value
ChDir Range("A2")
Workbooks.Open Filename:=Range(x) ----> Hear I get the error code However X is reading the respective file name and so does the chdir range (A2")

Any help is much appreciated.

Hey Holger,

Thanks a lot mate...It worked for me and thanks once again for the extra one...!!