Professor Excel

Comments 1

  1. Joe78man

    I usually record a macro and then edit it and paste it into a button or activeX and I noted that when I run the recorded macro it works, but if I copy and paste it into the vba editor and then run the step by step with F8 to see it do what I expected to do, some time it won’t.
    Same code, this is an example:

    If run as a recorded macro, it clears the contents as expected, but if run into an active x object, “Columns(“A:H”).Select” won’t select the columns.

Leave a comment

%d bloggers like this: