Hi all,

I need help to figure out what's wrong with the code below. I'm trying to fill cells down starting with C2, with the first 2 letters of the book's name, for as many rows having data in column A. However, when trying to run the code, I get an error message, saying "Compile error: Invalid or unqualified reference".

I'm not knowledgeable enough to figure out what needs to be changed or if there's a better approach to the task at hand. 
Range("C2:C" & .Cells(.Rows.Count, "A").End(xlUp).Row).Value = Left(ActiveWorkbook.Name, 2)