[Solved] vba excel: How to fill in two cells in a row with text

Question

Try this:

Inside the excel application go to the developer tab on the ribbon and click record macro.
Type the values into the two cells manually.
Click stop recording and view the macro it created.

This would show you VBA code that will work and you can compare it to what you have in order to trouble shoot.

This is called recording a macro and can be very helpful in solving problems. In fact I would suggest doing so almost every time before asking a question here.

Accepted Answer

Try this:

Inside the excel application go to the developer tab on the ribbon and click record macro.
Type the values into the two cells manually.
Click stop recording and view the macro it created.

This would show you VBA code that will work and you can compare it to what you have in order to trouble shoot.

This is called recording a macro and can be very helpful in solving problems. In fact I would suggest doing so almost every time before asking a question here.