Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
My simple macro is supposed cut a line from Sheet 1 and paste it to the first available Row in Sheet 2, and then delete the original line from Sheet 1. It would work, I think, if I could get past the first line. The first line is: Worksheets(1).ActiveCell.EntireRow.Select I get message: Run-time error `438': Object doesn't support this property or method. (My plan is to have user activate this macro with a hot key, like Ctrl + R., as he is scrolling through sheet and finds a line that should be moved.) What should the syntax be to select the row where the cursor is?? Thank you, Sam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Row-Entire row changes color (and stays) selecting first entry | Excel Discussion (Misc queries) | |||
i want to highlight entire row when selecting a cell in that row | Excel Discussion (Misc queries) | |||
Selecting entire rows contents | Excel Programming | |||
select cell rather selecting entire row | Excel Programming | |||
problem selecting entire column | Excel Programming |