1004:runtime error method 'range' of object'_Global failed

**trksbc** · 04-20-2009, 01:08 AM

Hi, I get the above mentioned error in VBA for the code:

Please Login or Register  to view this content.

What can be possible wrong with the code/syntax?

Thanks

**Norie** · 04-20-2009, 01:27 AM

Sorry but it's just wrong.

Why do you have Application.Match in there? Why the ...?

What is the code/formula meant to do?

**trksbc** · 04-20-2009, 01:32 AM

Sorry, the formula was not copied fully...

Orgid = Application.Index(Range("'Z:\work\[Data.xls]Sheet1'!F:F"), Application.Match(Range(FCode), Range("'Z:\work\[Data.xls]Sheet1'!A:A"), 0))

I want to get the orgID from workbook "Data" by looking up Fcode available in first column of "Data" workbook. I'll be using this code in a macro.

Thanks

**Norie** · 04-20-2009, 06:28 AM

Is the workbook Data.xls open?

What exactly is FCode a named range?

And finally, what are you actually trying to do?

**trksbc** · 04-20-2009, 08:35 PM

Hi,

Is the workbook Data.xls open?
Yes, the book will be always open.

What exactly is FCode a named range?
it is a value genetared during the execution of the program...
It is not a named range.

And finally, what are you actually trying to do?
I want to get the value ORGID from the "Data" excel sheet. I'll be searching for the Fcode in Data workbook in column A and picking the ORGID in that row in column F.

I'm novice programmer. Do let me know if I have not explained anything properly.

Thanks!

**Norie** · 04-21-2009, 03:25 AM

But what is FCode? An address for a range?

Using it like this Range(FCode) means VBA will be regarding it, whatever it is, as a reference to a range.