Yes but no need for the "" around the 5 If c.Value = 5 Then c.Offset(, 1).Value = c.Offset(, 2).Value
If c.Value = 5 Then c.Offset(, 1).Value = c.Offset(, 2).Value
Click here for a guide on how to add code tags Click here for a guide on how to mark a thread as solved Click here for a guide on how to upload a file with your post Excel 365, Version 2408, Build 17928.20080
Forum Rules
Posting Permissions
Reply With Quote