runtime error '1004 'Range of object _Global failed

[InfinityBeyond]

Hi
all of a sudden i am getting this error "runtime error '1004 'Range of object _Global failed".
earlier this used be working fine, dont know what happend as i am new to VBA.

when i debug this i am getting this error at the following code

Range(rcout & outcolml & 1) = Range("'heads'!" & outcolml & 1)

Can someone kindly help me out. thanks

 

[RoryA]

What are the values of rcout and outcolml when the error occurs?

 

[InfinityBeyond]

rcout ="'[so&so.xls].Sheet1'!"
outcolm1 = "A"

looks like Range("'heads'!" & outcolml & 1) is the issue.

 

[Marcelo Branco]

rcout ="'[so&so.xls].Sheet1'!"
outcolm1 = "A"

looks like Range("'heads'!" & outcolml & 1) is the issue.

What is the correct name of the variable? outcolm1 or outcolml?

M.

 

[InfinityBeyond]

ADVERTISEMENT

What is the correct name of the variable? outcolm1 or outcolml?

M.

outcolml is the correct one.

 

[RoryA]

Is that definitely what it is in your code when you assign the "A" value to it?

 

[InfinityBeyond]

yes Rory. variable is same outcolml .i have checked it again.