Thread
: [Solved]
Writing a VBA code for printing multiple sheets in a workbook
View Single Post
02-02-2016, 01:41 AM
Debaser
Windows 7 64bit
Office 2010 32bit
Competent Performer
Join Date: Oct 2015
Location: UK
Posts: 221
You can't check a range of cells like that (you're also actually testing range A6:F6, not just two cells).
You need separate checks:
Code:
If WS.Range("A6").Value2 = ChrW(&H2713) Or WS.Range("F6").Value2 = ChrW(&H2713) Then
Debaser
View Public Profile
Find all posts by Debaser