Run-time error ‘1004’: Method ‘Range’ of ‘object’_Global’ failed.

**dhiresh** · 03-07-2013, 06:26 AM

The scenario is that I have certain words in texts (Range Cells - C12:C68 , F14:F68) and where matched to the range of words with colours in Cells Z1:Z20 then the Macro when run should change colours of the words and the piece of code that is giving me the following error -
Run-time error ‘1004’:
Method ‘Range’ of ‘object’_Global’ failed.
And in the code line - MyColList = Application.Transpose(Range("MyRange").Value) is highlighting in yellow indicating where the problem is.

Please could someone help.

The code is:-

Please Login or Register  to view this content.

Thanking you in advance
warm regards
Dhiresh

**HaHoBe** · 03-07-2013, 09:19 AM

Hi, dhiresh,

proper Dims for the variables would have helped you solve the problem on your own.

You use

Please Login or Register  to view this content.

MyRange is of Type Variant as it hasn´t been specified, r is Range.

MyRange has neither been given the Address of any Range nor has it been set as a Range in your code.

If you address

Please Login or Register  to view this content.

there should be a cell or a range with the name of MyRange in the Worksheet which the code could refer to but then I would omit the variable of the same name.

HTH,
Holger