You have 3 multi-line If Then but only 2 End If
Options:
1. add End If before ActiveCell.Offset
2. make nested If a one-liner: If ActiveCell.Value <> "" Then ActiveCell.Value = "26 GA."
3. use ElseIf
You have 3 multi-line If Then but only 2 End If
Options:
1. add End If before ActiveCell.Offset
2. make nested If a one-liner: If ActiveCell.Value <> "" Then ActiveCell.Value = "26 GA."
3. use ElseIf
Last edited by June7; 02-02-2023 at 05:26 PM.
How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Reply With Quote
