Macro to autopopulate a section of the sheet, using a named range

Please Login or Register  to view this content.

I have this code which needs completed. The purpose is that if the text "Day" is put into A72, it will clear out cells A74:A108, and copy and paste the named range Time_Sheet_Stats_Day. If the named range does work well, the cells to be copied and pasted are ADMIN SHEET AM3:AM34. From there I could expand it so it will function based off of other text inputs. Thank you for your assistance.

Something like this?

Please Login or Register  to view this content.

That isn't working for me. The sheet that is being manipulated is Time Sheet, does that reference need to be in the code?

No, but the code does need to reside in that sheet's object (i.e. don't paste it in ThisWorkbook, or Module1, or anything else but the Time Sheet object)

When I type "Day" in A72 it gives me a compile error: sub or function not defined. The top line of code is highlighted yellow and the word worksheet is highlighted blue in this line,

Please Login or Register  to view this content.

Sorry, I forgot an "s". Replace that line with:

Please Login or Register  to view this content.

Thank you much! It worked.