I'm sure I posted a thread here last week about '1004 select method of range class failed', and got a reply asking for more of the code that was causing the error......but it's disappeared ! Was I dreaming or has the thread been removed ?
I'm getting "1004 select method of range class failed" on the Range statement below. This code is preceded by a number of range selection and formula-setting statements, nothing unusual.
Worksheets("summary").Select
Range("B5").Select
Any ideas ?
Bookmarks