Hi, is there a way to use IF statement to check whether cells have values in them? I'm using this code which doesn't work
The alternate i'm thinking of is individually checking each cell![]()
If Worksheets("Main").Range("O5:O16, P5:P16").Range <> "" Then 'code here end if
but it will make the codes look messy.![]()
If Worksheets("Main").Range("O5").Range <> "" Then if worksheets("Main").range("O6").range<> "" then 'code here end if end if
Bookmarks