Insert a row without taking formats from the upper row or cells

T

thelordmorgoth

I guess I need a VB code (or anything else) to prevent the excel from inheriting formats from upper row when I insert a row under a formatted row.

I know there is option to disable it but I need it only effects to one excel sheet which also has other VB codes.

I would also appreciated If you also you show me how I can code to prevent certain type of formats. I mean, the I inserted row only inherits "BOLD" from the upper row. A reference of functions would help.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert a row without taking formats from above (upper) rows or cells 6
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Insert Row formatting 1
Extracting data from Multiple columns to a Single row 3
Help needed for inserting a row. 0
How do I insert a row without the formula changing? 1
Array with many cells from a row but not in order or together 11
looking for empty row to paste a range of copied cells 1

Top