Macros

Hello Jassen,

Hope you enjoyed your Microsoft training courses with Best STL.

Thank you for your question regarding creating a macro to insert single cells in worksheet.

As you probably already know that to insert a single into existing data either shifting cells down or to the right is done by right-clicking a cells or group of cells, then clicking Insert and finally Shift Cells Down or Right then clicking OK.

To create a macro to this, create some data (a block of numbers will do) and click somewhere on a cell in the data area then start to record your macro. Give the macro a name such as InsertCellsDown and store it into your Personal Macro Workbook. Follow the exact procedure as you would normally do (as outlined above) and when finished Stop Recording. Test the macro on some other data then add the macro to your Quick Access Toolbar.

You cannot use this macro to insert cells by shifting cells to the right. This will have to be done as separate macro.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer