How do I specify a cell in VBA using a column letter, and a row # stored as a value?
CR is my "current row" that I am working with. It has been declared as a value
Set box = .document.all.Item(ThisWorkbook.Sheets("tbas").Range("A & CR").Offset(1, 1).Value)
This didn't work, but I don't know how to do it....it has to be simple.
CR is my "current row" that I am working with. It has been declared as a value
Set box = .document.all.Item(ThisWorkbook.Sheets("tbas").Range("A & CR").Offset(1, 1).Value)
This didn't work, but I don't know how to do it....it has to be simple.