Thread: [Solved] Writing a VBA code for printing multiple sheets in a workbook
View Single Post
 
Old 02-02-2016, 01:41 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
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
Reply With Quote