Hello,
I year ago I asked this question and I got a great answer but now I need some help creating a conditional statement within the code:
The code below will in its current state insert "x" amount of rows dependent on the specified "row interval."
Sub InsertRowsAtIntervals()
'Updateby...
I'm using the below VBA to add a blank row where my data changes in my sheet. The Instruction is working fine. However, I'm trying to add a formula into the blank line that this code creates in column "C" of the inserted row.
When I added the working formula to the code after the "insert"...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.