Problem is using any method of Range Object
 

Hi,
I have a code where I am using this code

Worksheets("Input").Range("A5:B5").Select

It is giving Run time Erro 1004
Select Method of Range Class failed
Why is this giving this error?
TIA
Shilps

Problem is using any method of Range Object
 

Hi
are these cell eventually locked?. Also does sheet 'Input' exist (and
is not hidden)?

--
Regards
Frank Kabel
Frankfurt, Germany


Shilps wrote:
Hi,
I have a code where I am using this code

Worksheets("Input").Range("A5:B5").Select

It is giving Run time Erro 1004
Select Method of Range Class failed
Why is this giving this error?
TIA
Shilps

Problem is using any method of Range Object
 

Nope, neither the cells are locked nor is the sheet hidden

"Frank Kabel" wrote:

Hi
are these cell eventually locked?. Also does sheet 'Input' exist (and
is not hidden)?

--
Regards
Frank Kabel
Frankfurt, Germany


Shilps wrote:
Hi,
I have a code where I am using this code

Worksheets("Input").Range("A5:B5").Select

It is giving Run time Erro 1004
Select Method of Range Class failed
Why is this giving this error?
TIA
Shilps

Problem is using any method of Range Object
 

Can't really tell......but possibly you are not activating the "Input
sheet before selecting it

Try this:
Worksheets("Input").Activate
Worksheets("Input").Range("A5:B5").Select

Abhi

--
Abh
-----------------------------------------------------------------------
Abhi's Profile: http://www.excelforum.com/member.php...fo&userid=1585
View this thread: http://www.excelforum.com/showthread.php?threadid=24754