Problem is using any method of Range Object

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi
are these cell eventually locked?. Also does sheet 'Input' exist (and
is not hidden)?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selection.AutoFill Destination:=Range 0
Printing issue 1
Hide Rows Using Checkbox 3
Run-time error when copying entire row! 5
"Run-time error '1004' 5
CopyPicture method of range class failed using RangeName 5
Autofilter problem 7
Error on Autofill 2

Back
Top