Excel VBA - Run Time Error 1004 HELP ME!!!!!!

[Cass]

To my potential rescuer...

I am trying to activate cell A1 in a spreadsheet but I keep getting this
error message: run time 1004

The code is below and the error kicks in on the last line:

Workbooks("PIVOTS.xls").Worksheets("Campaign").Activate
Row_Count = 1
Col_Count = 1
Cells(Row_Count, Col_Count).Select



The irritating thing is that this piece of code is not "clever" or "fancy"
and was working, I haven't made any changes to it and am the only one using
these files. Apologies- rant over.

Many Thanks

 

[Gordon Bentley-Mix]

Cass,

This is the Word Programming newsgroup. You might have better luck if you
posted this in the Excel Programming newsgroup.
--
Cheers!

Gordon Bentley-Mix
Word MVP

Uninvited email contact will be marked as SPAM and ignored. Please post all
follow-ups to the newsgroup.

 

[Doug Robbins - Word MVP]

Use Cells( ConvertFormula(Row_Count, Col_Count, xlR1C1, xlA1)).Select


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP