Member Avatar for leecavcu

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).

  • 1 Contributor
  • 1 Reply
  • 92 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by leecavcu
Member Avatar for leecavcu

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.