Insert X rows Macro modification

**drgkt** · 10-07-2017, 05:48 AM

Hi
Please show me how to modify the following macro so that the rows inserted in that column are selected and the OPTION BOX to format as above, below or clear formatting is shown.

Thanks!

Please Login or Register  to view this content.

**Richard Buttrey** · 10-07-2017, 07:35 AM

Here's one way

Please Login or Register  to view this content.

**drgkt** · 10-07-2017, 11:27 AM

That neither selects inserted rows nor presents the formatting option box.
See the difference between running the macro, and inserting the rows by the menu commands.

**Richard Buttrey** · 10-07-2017, 12:27 PM

Your original macro didn't select cells and neither does mine. They both USE what happens to be selected when you run the macro, the only difference is your macro accepts a range of cells and then you use a loop to process the cells. A loop is not necessary since you're specifying the number of rows to insert. Hence I simplified and removed the loop (loops should always be avoided if possible since they are not efficient in terms of overhead time when large ranges are involved).

Neither am I clear what you mean by the formatting option box. It's standard Excel functionality to carry the formatting on the selected row to rows you introduce. Or it is on Excel 2007 --->

Maybe it's because you apparently have Excel 2002. In which case try adding the copyorigin instruction.

Please Login or Register  to view this content.

**drgkt** · 10-07-2017, 12:34 PM

The formatting option box is the brush icon that appears in one of the above pictures.

May I have a choice by means of a drop down to choose the CopyOrigin?

edit: and modify in order to select inserted rows?

**Richard Buttrey** · 10-07-2017, 01:23 PM

Hi,

Maybe

Please Login or Register  to view this content.

**drgkt** · 10-07-2017, 01:58 PM

A,a,B,b inserts row BELOW selection and formats as BELOW. It should insert row above selection and then if A,a format as above, if B,b format as below.

C,c inserts row BELOW selection and clears formatting. It should insert row above selection and clear formatting.

Inserted rows still are not selected after macro end.

**drgkt** · 10-07-2017, 04:07 PM

This works ok.
The function of selecting the inserted rows on macro end is still wanted.

Please Login or Register  to view this content.

Insert X rows Macro modification

LinkBack

Thread Tools

Rate This Thread

Display

Insert X rows Macro modification

Re: Insert X rows Macro modification

Re: Insert X rows Macro modification

Re: Insert X rows Macro modification

Re: Insert X rows Macro modification

Re: Insert X rows Macro modification

Re: Insert X rows Macro modification

Re: Insert X rows Macro modification

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to insert specific number of rows, populate rows with data above except date

[SOLVED] Insert row macro modification

Insert date for last workSHEET modification

macro to highlight two rows, insert at first highlighted row to shift down, copy two rows

[SOLVED] Macro code to insert 3 rows on spreadsheet with variable number of rows

Macro: Copy 3 Rows & Insert below with Format....Also hide last two rows inserted

Multi functional macro- insert rows, copy data- but never sure how many rows it will

Bookmarks

Bookmarks

Posting Permissions