Thanks for the help. I have a workbook with VB code in it to add a new line. When I add a new line, the new cells automatically have their respective formulas in it. I also have it set so another worksheet with the same table adds a line. In the second worsheet, I want text from the first worksheet inserted into the cells of the second worksheet. Here is the line that is giving me problems in my code. Everything is defined correctly. I think it is just a syntax error.

[roomM = "=IF(ISBLANK('Air Balance (e)'!$A" & newrow & "),"" "",'Air Balance (e)'!A" & newrow & " "
Cells(newrow, 1).Formula = roomM]

"newrow" is an integer. It defines the row number of where you inserted the new row. "Air Balance (e)" is the first worksheet. So, if cell (A,newrow) in Air Balance (e) is blank, then display nothing. Otherwise, display cell (A, newrow) from worksheet Air Balance (e).

9 Years
Discussion Span
Last Post by leecavcu

Never mind. I was missing a ) in the first line at the end. I've been staring at this too long.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.