Hello, I would like to copy a range from an Excel workbook up to a certain row that may change daily. I can extract the row number however I am not sure how to use it in the copy/paste range function.
I would like to accomplish something to the extent of the following:
int rowcount = last row to select
Copy/Paste Range
Source:
Excel.Sheet(“Report”).Range(“A1:AE(row count)”)
Destination:
Excel.Sheet…
So if rowcount = 10 than I want to select A1:AE10.
Is there a way to accomplish this?
Thank you!