Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to go to the last used cell in Column A, move over 5 to the right, and
then select the range from Column F to Column BR. I'm trying to run the code below, keeps failing on this line: ActiveCell.Resize(0, 65).Select Code: Cells(Rows.Count, "A").End(xlUp).Select ActiveCell.Offset(0, 5).Select ActiveCell.Resize(0, 65).Select Selection.Copy Sheets("Scoring_Sheet").Select Range("B3").Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True I must be missing something pretty basic. I thought this was done with resize and select. Any suggestions? Thanks, Ryan--- -- RyGuy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select ActiveCell Range | Excel Programming | |||
ActiveCell.Row in Range().Select? | Excel Programming | |||
Range Select with ActiveCell and Offset property | Excel Programming | |||
select range next to activecell | Excel Programming | |||
Select Activecell in Range | Excel Programming |