Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following code excutes as shown, however the 2nd Range Select statement
receives run time error '1004'. When I manually select A1 of sheet "data" and press cntl + end, cell "U53" is selected. What am I overlooking? TIA, Lee Set rnge = wb.Sheets("MoreStats").Range("A1") Range(rnge, rnge.End(xlDown).End(xlToRight)).Select Selection.clear Sheets("data").Select Set rnge = wb.Sheets("data").Range("A1") Msgbox rnge.address 'Shows "$A$1 Range(rnge, rnge.End(xlDown).End(xlToRight)).Select '*** This one fails Selection.copy |