runtime error 1004

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

geebee - 21 Sep 2007 16:44 GMT

hi,

i have the following code behind a button in sheet1:
sheets("pivot").select
range("F2").select

but when i click the button in get the following message:
runtime error 1004: select method of range clas failed.

i did a small test to place the code and button in the same worksheet as the
range (pivot sheet), and it worked just fine.

Reply to this Message

Jim Thomlinson - 21 Sep 2007 17:44 GMT

Code in a sheet always refers to that sheet unless otherwise specified. So
your code select the pivot sheet but then it tries to select range F2 on
itself (sheet 1). Try this..

with sheets("pivot")
.select
.range("F2").select
end with

Signature

HTH...

Jim Thomlinson

> hi,
>
[quoted text clipped - 7 lines]
> i did a small test to place the code and button in the same worksheet as the
> range (pivot sheet), and it worked just fine.

Reply to this Message