Hello Everyone,
Hope you all are safe.
I need your help to create a code,
I have one macro on button which collect and generate something
Sub Button20_Click()
Range("C12:T16").Select
ActiveCell.FormulaR1C1 = "=R[8]C[25]"
Range("C10").Select
Range("C12").Copy
End Sub
if A2 and D2 are blank and user click on button, there would be msgbox stating that pls provide value in these cells. please help me.
Hope you all are safe.
I need your help to create a code,
I have one macro on button which collect and generate something
Sub Button20_Click()
Range("C12:T16").Select
ActiveCell.FormulaR1C1 = "=R[8]C[25]"
Range("C10").Select
Range("C12").Copy
End Sub
if A2 and D2 are blank and user click on button, there would be msgbox stating that pls provide value in these cells. please help me.