| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows vb statement
After using macro recording for a single insertion of a row, the recording
showed this: Rows("50:50") followed by in inser command, my question is How do I make this Rows statement become Macro friendly? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rows vb statement
Maybe
Activecell.entirerow.insert or Activecell.offset(1,0).entirerow.insert Rick wrote: After using macro recording for a single insertion of a row, the recording showed this: Rows("50:50") followed by in inser command, my question is How do I make this Rows statement become Macro friendly? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding rows with an if statement | Excel Worksheet Functions | |||
| if statement using rows and columns | Excel Discussion (Misc queries) | |||
| Incrementing Rows or Colums After Running Through an IF Statement | Excel Discussion (Misc queries) | |||
| Countif statement doesn't work on some rows | Excel Worksheet Functions | |||
| Deleting rows based on IF statement | Excel Discussion (Misc queries) | |||
Hybrid Mode
