• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA: Copying previous row formulas/formats to the inserted row

I

inddon

Member
Hello There,

I would like to know if this would be possible using VBA. When the user is inserting a row, I would like the previous row formulas, Data validation and its formatting to be automatically copied to the newly inserted row or rows.

Thanks & regards
Don
 

Attachments

  • Copy previous row Formulas on Insert row(s).xlsx
    11.6 KB · Views: 7
Don

Have you considered setting this table up as a Data Table
Select the Table B11:H21
Insert, Table

Tables automatically copy formulas and formatting

But in B12 I would use: =ROW()-11
 
Hui said:
Don

Have you considered setting this table up as a Data Table
Select the Table B11:H21
Insert, Table

Tables automatically copy formulas and formatting

But in B12 I would use: =ROW()-11
Click to expand...


Thanks Hui for your reply.

Apart from data table, is there another method which can be done via VBA?

Thanks & regards
Don
 
You must log in or register to reply here.
Back
Top