Run-time error when running macro from personal workbook

Hi,

I have a very simple macro that i use to divide a an entire column (besides the header row) by 1000...

Please Login or Register  to view this content.

It works fine as long as the macro is attached to the workbook in which I am trying to use it. If the macro is attached to the personal workbook, I get a runtime error when I attempt to run it...

Run-time error '1004':

Method 'Range' of object '_Worksheet' failed

When I hit Debug, this line is highlighted...

Please Login or Register  to view this content.

There appears to be some confusion when the range is defined, but I don't see why which workbook the macro is attached to should make a difference.

I am VERY new to this, so any help would be appreciated.

Thanks,
Corey

Here's another way:

Please Login or Register  to view this content.

.

Thanks very much for the replies guys. Rick's code worked like a charm. When I tried shg's code, I got the following error:

Run-time error '1004':

No cells were found

Upon debugging, the following line of code was highlighted...

Set rBlank = ActiveSheet.Cells.SpecialCells(xlCellTypeBlanks).Cells(1, 1)

Like I said, I'm a complete noob, so it's entirely possible that I deployed it wrong. I've just been cutting and pasting these into Visual Basic. Any thoughts?

Thanks again for your replies and patience.

-Corey

Rick's code worked like a charm. When I tried shg's code, I got the following error

Go, Rick

Don't see why mine should error unless the sheet is full, but haven't looked closely.

You guys are awesome.

Stay tuned for more new guy type problems

Thanks Rick!