Hi,

I have been running into an issue for years since I first started coding in
VBA within Excel -- it has driven me crazy and significantly effects my
ability to write code without having to record a macro...the issue appears to
be interment and just seems to not make logical sense.

The issue is that for some reason, when I write, for example, the code below
sometimes it does not work and I get the error listed below. When, however,
I copy the same line of code from another sub, where that same code works,
THEN the error stops coming up. It is literally that the code is identical -
it is just that when I copy it from another sub where the code has worked
INSTEAD of typing the code out, then the code works. Any insight would be
GREATLY appreciated as this is killing me -- it is like water torture -- it
has gotten to the point where I can't take it any more :) I want to
understand what the issue is and how I can avoid it.

Code:
Sheets("Payment Sales Master").Range(Rows(2),
Rows(2).End(xlDown)).ClearContents

Error:
Run-time error '1004':

Application-defined or object-defined error

--
Robert