Thread: referencing relative cell
View Single Post
 
Old 08-11-2019, 09:31 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default
try
Code:
        If xCell.Value Like "*@*" And xCell.offset(,2).value = "No" Then
Reply With Quote