Free for PREMIUM members
Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium
.Range("K7", Range("C" & Rows.Count).End(xlUp).Offset(, 8)).FormulaR1C1 = "= ""#RET"""
Open in new window
Dim RwCnt As Long
RwCnt = Cells(Rows.Count, 3).End(xlUp).Row
If RwCnt < 7 Then
MsgBox ("No Data Found!")
.Range("K7:K" & RwCnt).FormulaR1C1 = "= ""#RET"""
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.