Range object

[jasmine123]

Hi,

I have below lines of code in VBA:

Please Login or Register  to view this content.

During execution, below error is thrown in second line:

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

Can anyone say what I am doing wrong.
Thanks in advance.

[Marcol]

Please wrap your code in code tags, before the moderators get you...

Forum rules

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button.

This is where the problem is

Please Login or Register  to view this content.

Excel 2003 only has 65536 rows

Perhaps this is what you are after

Please Login or Register  to view this content.

Note also the Range address is in quotes.

Hope this helps

[johnjohns]

try

Please Login or Register  to view this content.

rgds
johnjohns

ps
always use code tags
Try this only in exel 2007 or later versions. Older versions having less than 66000 rows

[arthurbr]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here