Select method of range class failed

mikezcg · #1 (**permalink**) 05-30-06, 06:38

This is CRAZY i have this sub in my sheet(1), i copied to sheet 2 and am using it from a btn Click event. i get the errror :
Select method of range class failed
runtime error 1004 on the 2nd row "Range("A3").Select" is this because the sub is in sheet 1 and i want it to work with another sheet?

How can i call subs from this workbook, a modual from diff sheets? I konw it can be done just dont know how to qualify the sub

Sub SetLastRow()
Sheets("DataSet").Activate

Range("A3").Select
Selection.End(xlDown).Select
LastRow = ActiveCell.Row
End Sub

norie · #2 (**permalink**) 05-30-06, 06:53

The error is probably because you are running the code from a button.

Does this work?

Code:

Sub SetLastRow()
     LastRow =Sheets("DataSet").Range("A3").End(xlDown)
End Sub

In Excel VBA you rarely have to select/activate ranges etc to work with them.

mikezcg · #3 (**permalink**) 05-30-06, 08:38

I added .row and it works, why was there a problem? Maybe i should put all my code in a class and use that, would that solve the probl?

MikeTheBike · #4 (**permalink**) 05-30-06, 08:59

Hi Mikezcg

Yes, if you want to run code that relates to, or selects, different sheet than it should be in a Moduel, but not a CLASS Mode as you seem to suggest (that is a different object!).

MTB

norie · #5 (**permalink**) 05-30-06, 10:34

mikezcg

Using a class module is not the solution.

The reason for the problem was because the selection when you pressed the button was the button itself.

Internet Services

Web Development

Digital Marketing

Consumer Tech