I'm trying to combine 2 variable column refs and 2 fixed numbers to select a range in VBA, but I can't get the correct syntax re the number of inverted commas.
(strFrom and strTo are the column variables, already defined)
I've tried every combination (except the right one!) for over an hour and just cannot get this to work.
If someone can also explain the logic around the number/placement of inverted commas it would be much appreciated - since they're all straight, I'm never sure whether I'm closing a set or opening a new set.