Professor Excel

Comments 2

  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.

  2. Richard


    I need your help to create macro. My requirement is given below.

    Eg: By using macro open google website enter Text1 on search bar, and again clear the search bar and enter Text2… so on Textn

    Note: The value of Text 1, Text2… Textn has been taken from the excel sheet.

Leave a comment

%d bloggers like this: