ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel macro (https://www.excelbanter.com/excel-programming/354865-excel-macro.html)

Reg Schulz

excel macro
 
I'm a macro novice.
I used the "record macro" mode to create a macro which inserts cells
(rectangular array) in a spreadsheet. The number of rows of the array to be
inserted is different each time the macro is excuted.
I need to modify the excel macro so I can cause it to insert a varied number
of rows at macro execution. The number of rows to insert would be defined in
a cell and would be entered before program execution.

Any help would be appreciated.
--
Reg

Don Guillett

excel macro
 
As always, post your efforts for suggestions.

--
Don Guillett
SalesAid Software

"Reg Schulz" wrote in message
...
I'm a macro novice.
I used the "record macro" mode to create a macro which inserts cells
(rectangular array) in a spreadsheet. The number of rows of the array to
be
inserted is different each time the macro is excuted.
I need to modify the excel macro so I can cause it to insert a varied
number
of rows at macro execution. The number of rows to insert would be defined
in
a cell and would be entered before program execution.

Any help would be appreciated.
--
Reg





All times are GMT +1. The time now is 12:31 PM.

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