I wrote a VBA macro for Excel, and in a preliminary step I want to copy today's worksheet ("Schedule") into a "Old Data" worksheet and then bring new data into the "Schedule" worksheet. In order to copy the entire worksheet I have:
This used to work. Now I am getting a pop-up window when I step through to the first Cells.Select line. The pop-up simply reads "400", with "OK" and "Help" buttons. "Help" brings up a blank screen.
Can someone explain to me what is happening?
Can someone explain how I can accomplish what I want?
Also, is it possible to select an entire worksheet and then paste it over another worksheet, skipping row 1 (where I have buttons, which can't be overwritten), when the size of the worksheets changes daily?