G Guest Nov 23, 2004 #1 Is it possible to use an output number so that if a cell is blank that it will put a specified number in another cell? Thanks.
Is it possible to use an output number so that if a cell is blank that it will put a specified number in another cell? Thanks.
G Guest Nov 23, 2004 #2 Sets y = 10, then checks to see if there is a value in B1, if both are true, then it puts the value of in B1. Sub Macro1() y = 10 If y = 10 And Range("B1") = "" Then Range("B1").Select Range("B1").Value = y Else End If End Sub
Sets y = 10, then checks to see if there is a value in B1, if both are true, then it puts the value of in B1. Sub Macro1() y = 10 If y = 10 And Range("B1") = "" Then Range("B1").Select Range("B1").Value = y Else End If End Sub
G Guest Nov 23, 2004 #3 Thank you.... David said: Sets y = 10, then checks to see if there is a value in B1, if both are true, then it puts the value of in B1. Sub Macro1() y = 10 If y = 10 And Range("B1") = "" Then Range("B1").Select Range("B1").Value = y Else End If End Sub Click to expand...
Thank you.... David said: Sets y = 10, then checks to see if there is a value in B1, if both are true, then it puts the value of in B1. Sub Macro1() y = 10 If y = 10 And Range("B1") = "" Then Range("B1").Select Range("B1").Value = y Else End If End Sub Click to expand...
