Datenkultur
asked on
Excel Range - How to get a reference of a range by coordinates ?
Hi all,
I need to get an excel.range-object. I have the coordinates of the range (X,Y, the row-count and the column-count).
I only found:
Set rngResult = objWorksheet.cells(x,y).
But i need something like:
Set rngResult = objWorksheet.cells(x1,y1,x 2,y2).
Is there a standard function, or do I have to implement it myselfe?
I need to get an excel.range-object. I have the coordinates of the range (X,Y, the row-count and the column-count).
I only found:
Set rngResult = objWorksheet.cells(x,y).
But i need something like:
Set rngResult = objWorksheet.cells(x1,y1,x
Is there a standard function, or do I have to implement it myselfe?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.