I was wondering if there's any easyway (make that any way at all) to reference a range of cells given a row and column variable. I've got a loop that runs through an excel file that formats and writes data, but I need to merge a few cells.
The only current way I know how to reference a range is: ExlObj.Range("A1:A2"), and that works fine, but I don't know how to convert my col/row variables into a string like that.
If anyone know's, could you post a code sample using 'Row' and 'Col' to reference a range?
The only current way I know how to reference a range is: ExlObj.Range("A1:A2"), and that works fine, but I don't know how to convert my col/row variables into a string like that.
If anyone know's, could you post a code sample using 'Row' and 'Col' to reference a range?