I have an issue that I can’t seem to get my head around. Any help would be welcome. Thank you in advance for being patient.

BACKSTORY: What I want to do:

I want to write a Do…Loop function that would:

- Determine if a specified start cell in Column C is populated; AND
- Offset to Column K to see if the value is blank.

If both of the above are TRUE, then offset to a column a VARIABLE distance away and clear contents. The variable distance is located on the same spreadsheet in cell L12 as an integer.

…and loop until a blank cell is found in Column C.

ISSUE:

Got the do/loop coding, no prob there. But offsetting by the variable in L12 is giving me cramps. Hope this is succinct and not too pathetic a question. Any suggestions would be greatly appreciated.