I am trying to copy and paste a download into another excel. The downloaded file will have different rows based on the source data.
I figured out how to find the last row number and I named that “Last_Data_Row”. Now I’m trying to add that number to my Copy and paste range.
SourceData.Sheet("Source Data "+DateTime.Now.ToString(“dd-MM-yyyy”)).Range(“A2:E”+(Last_Data_Row.toString))
That is not working.
I’ve played with quotes and parenthesis but I am brand new to StudioX and admittedly don’t know what I’m doing.
I’d appreciate any advice.
Thank you in advance,