What does "range("F:F")" mean in an Excel macro?
excel, vba
Solution
It means the range that is the entire `F` column. `F:H` is columns `F`, `G` and `H` etc.
Problem
I'm debugging a macro and have very little experience with them, what does the f:f mean? I understand the first range and I'm guessing the f:f means the currently selected range but that's just a guess. ``` ws.Range("A1:M65536").ClearContents ws.Range("F:F").FormatConditions.Delete ``` Could someone clarify for me please?