Range Offset
I'm not exactly sure what you mean by "range letter"? If you mean
column G of the worksheet, you could do something like:
Cells(cell.Row, Range("G:G").Column).Value = "x"
On Oct 31, 8:29 pm, "jsd219" wrote:
Hi all, can anyone help me with this line:
cell.Offset(1, .Range "G").Value = "x"
I am trying to offset a row to a specific column
this is what the original line read:
cell.Offset(1, -5).Value = "x"
I was hoping to use a range letter instead of a number.
|