Hi all,
I have 2 very closely related problems that probably require very similar code:
1). In a sheet called "4. Class Data", the content of cell A1 is: "A123 Example Rd, Town Site 1 ATC Report"
In VBA, I have a String variable called "Site_Ref"
I need a line of code which extracts the "Site 1" bit from the cell reference and assigns it to Site_Ref.
This code will be applied to different cells which will have the same wording format as above, but different Site #.
I know it should look something like this, but this would extract the whole cell content, not just the middle bit I need:
2). Cell A2 in my active sheet has the value "Class Data, Day 1 - Monday 6th, June 2022"
I have an If statement in VBA that says if cell A2 contains the word "day", Then continue through the if statement.
The following doesn't work:
Any help on either issue (or both) would be greatly appreciated!!
Bookmarks