HELP! Adding Rows with a macro

[kkavanagh]

I am still struggling with this....
I have attached a spread sheet where I want to add the number "1" under "Issue No" and "1" under "Action Step" by clicking a button and subsequently if additional actions are needed then I would like to click the other button to add additional Action Steps as needed.

Ok I have figured it out the above

BUTTTT..... is there a way to auto format the cell that contains the issue if there are multiple actions.... ie. if there are 2 actions steps then the issue needs to be merged into 2 cell, if 3 action steps then merge issue into 3 cells.

thanks
Kelly

[maniacb]

Try the AddAction code as follows, but you should know, mixing Cell merge with VBA is not something one should do.

Please Login or Register  to view this content.

[maniacb]

Here is code updated for formatting

Please Login or Register  to view this content.

[maras_mak]

Try this ...
I use hidden 'tmp' sheet in VBA code.
To add an 'Action Step' select a given line for a given 'Issue' and select the 'Add new action' button.

Please Login or Register  to view this content.

[kkavanagh]

Hi Maras,

Thank you! How do I remove the bright green colour on the date cell? I will add conditional formatting later...

Thanks
Kelly

[maras_mak]

You can like below.
Select the cells that you will remove solid fill colors from, and click Home > Fill Color > No Fill.

[kkavanagh]

But they come up every time I click the new issue button

[kkavanagh]

When you click the New Issue button the date cell in column J keeps coming up bright green, I just want it to be "clear" with no fill....

[maras_mak]

Sorry, unhide the sheet 'tmp' and remove the conditional formatting from cell 'J2'. Then hide the sheet back.

[kkavanagh]

That's perfect! Many thanks!

[maras_mak]

Glad to help.