> I'm trying perform the following with a VBA script in Excel 2000:
> 1. Unhide a hidden worksheet.
> 2. Copy a range of cells from another worksheet
> 3. Paste the copied selection into the worksheet that was unhidden.
> 4. Some simple formatting steps in the unhidden worksheet
> But the script is failing when I tried to Paste.
> Here's the code:
> Private Sub cmdZoomProgSumm_click()
> Sheets("Project Summary").Visible = True
> Sheets("6-Blocker").Select
> Range("B5:R33").Select
> Application.CutCopyMode = False
> Selection.Copy
> Range("B5:R36").Select
> Application.CutCopyMode = False
> Selection.Copy
> ActiveWorkbook.Sheets("Project Summary").Select
> Range("A1").Select
> Selection.Paste
> Columns("A:A").ColumnWidth = 5.29
> Columns("A:P").Select
> ActiveWindow.SmallScroll ToRight:=6
> Columns("A:Q").Select
> Selection.ColumnWidth = 4.71
> ActiveWindow.SmallScroll ToRight:=-6
> End Sub
> I'm getting the error 1004 "Select method of Range class failed"
> where I specify Range("A1").Select
> The odd thing is that when I ran the code as a recorded macro, it
> worked fine. However when I copied the code to a VBA button control, I
> got the 1004 error.
> Can somebody explain why I'm getting this error on the button control
> and what I can do to solve this problem?
> Thank you in advance.
