Macro Select Issue

[MikeG]

I have a macro that I activate in Sheet1.

It includes the following:

FR=100
FC=2
Sheets("Quotes Database").Cells(FR, FC).Select

My intention is simply to jump to the other worksheet (Quotes Database) and go to the specified cell. However, the macro causes an error - Runtime Error 1004 Slect method of Range class failed.

Can anyone help?

Thanks,

MikeG

 

[shg]

If Quotes Database is a worksheet, that code should work fine.

No, Private has nothing to do with it.

 

[MikeG]

If Quotes Database is a worksheet, that code should work fine.

No, Private has nothing to do with it.

Hmm... It does cause an error. strange.

But anyway, thanks, and the copy/paste you gave me works great.

MikeG