jebenexcel
Board Regular
- Joined
- Mar 16, 2018
- Messages
- 59
Hello,
I have to modify a tool that makes new OBR sheets (OBR (2), OBR(3)) . I need to refer to cells in these newly made sheets in a for loop on the sheet Uaar from B94 onwards. I have to move down one cell for every reference. Something like this?
Sheets("Uaar").Range("B" & "93 +i").Formula = "=IFERROR(IF('OBR1 (" + "i" + ")'!C13<>"";'OBR1 (" + "i" + ")'!C13;"");"")"
I'm unsure of my " and ' placement... and some other stuff
I have to modify a tool that makes new OBR sheets (OBR (2), OBR(3)) . I need to refer to cells in these newly made sheets in a for loop on the sheet Uaar from B94 onwards. I have to move down one cell for every reference. Something like this?
Sheets("Uaar").Range("B" & "93 +i").Formula = "=IFERROR(IF('OBR1 (" + "i" + ")'!C13<>"";'OBR1 (" + "i" + ")'!C13;"");"")"
I'm unsure of my " and ' placement... and some other stuff