ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro for inserting a row (https://www.excelbanter.com/excel-programming/371070-macro-inserting-row.html)

Kazuki

macro for inserting a row
 
is there a macro to insert rows below any row with the same formatting,
including the merging in the source row?


[email protected]

macro for inserting a row
 
Kazuki san,
try this:
Sub copytest()
ActiveCell.Copy ActiveCell.Offset(1, 0)
ActiveCell.Offset(1, 0).Activate
End Sub

rgds,

Halim

Kazuki menuliskan:
is there a macro to insert rows below any row with the same formatting,
including the merging in the source row?




All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com