I have a column (A) with 12 months January to December in a Column.
I have loaded those months into an array like;
I have Sheet names with the names of the Array namesDim myArray As Variant myArray = Application.Transpose(Worksheets("Sheet1").Range("A1:A12"))
How can I loop through that array to act on cells on each sheet in the array.
Something like
I get an error " Object Required "For Each sh In myArray sh.Range("D1").Value = DONE
Thanks