Hi all. I have the code:
///
.range("a1:a100").specialcells(xlcelltypevisible).formula = "=if(c3=""2","""",d3)"
///
this puts that formula into my visible cells. but the thing is, the first visible cell will be equal to that formula exactly. for example, if my first visible cell is a50, it will still say =if(c3="","",d3). is there a way to make it say =if(c50="","",d50) instead? so a way of setting x to row length?
Thanks.
///
.range("a1:a100").specialcells(xlcelltypevisible).formula = "=if(c3=""2","""",d3)"
///
this puts that formula into my visible cells. but the thing is, the first visible cell will be equal to that formula exactly. for example, if my first visible cell is a50, it will still say =if(c3="","",d3). is there a way to make it say =if(c50="","",d50) instead? so a way of setting x to row length?
Thanks.