Add IF Statement formula to cells in varying range and paste to used range

[Webbers]

I am writing a VBA script, and all parts of it work perfectly (pats self on the back). Now I need to add one more section to it.

Data range is columns A - M, headers in row 1, data begins on row 2. The number of rows varies each time this report is run, but there is always a value in column A if there is data in that row, so Column A is my variable for this determination. Basically if I was using a traditional formula, I would write it up as:

Please Login or Register  to view this content.

Column A is a unique ID # for each person. Column C, which lists the person's name is the variable to determine whether it is Automated or Manual. If the cell is blank, then Column M must reflect "Manual", however if column M is populated with a value, the "Automated" must display. I need this formula to be copied down to all cells within Column M that have a value in Column A. Once that is done, I need to copy and paste as values.

Now I attempted to do this myself, and got an error, Compile Error: Expected: End of Statement. I am still relatively new to VBA, and this particular task I have never attempted in VBA... double trouble.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[Webbers]

John----

That appears to work fine, however since I am building this for another user, I am trying to be able to avoid having them run multiple macros. I attempted to call the macro at the end of my previous macro, however it did not work right (it overwrote the Header in cell N1 with "Automated", entered "automated in cell N2, which is correct, and then all the other rows in this column are blank, however column A is populated until row 1547. How do I add this to my existing macro code. So you can "see what I am saying... this is my initial code, and then your code, which I am calling

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Change to:

Please Login or Register  to view this content.

[Webbers]

wooohooo works great! thanks so much... sorry for the delay in responding, too many meetings! Appreciate all your help!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as solved.