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

Question

I need to make a header in my excel sheet using VBA. Seems pretty simple, but when I do this

Worksheets("New_Students").Range("A1").Value = "studentID"
Worksheets("New_Students").Range("B1").Value = "ISUID"

only the first line works and not the second one. What am I forgetting?

Answer 1

Try this:

1. Inside the excel application go to the developer tab on the ribbon and click record macro.
2. Type the values into the two cells manually.
3. 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.