topic How do I write the expression for Cell reference if the end cell is variable in Product Forum

How do I write the expression for Cell reference if the end cell is variable

Fran.Woodcock — Thu, 11 Jan 2024 15:35:00 GMT

Hi all

Can anyone help me work out an expression?

I am using the MS Excel VBP (v10.1.10) and the Copy & Paste Worksheet Range action. My Excel spreadsheet end cell will change so I have included a Get Number of Rows action to get the end cell number, but I am stuck in trying to write the expression of the Ranges in the C&P action

This is my overall object:

This is the Copy & Paste action open:

I get the exception thrown as this which is vague as anything... but stepping through the VBO doesn't make it any clearer (to me)...

Many thanks

Fran

------------------------------
Fran Woodcock
------------------------------

RE: How do I write the expression for Cell reference if the end cell is variable

MichealCharron — Thu, 11 Jan 2024 15:40:00 GMT

@Fran.Woodcock

I think your forgot to concatenate the row number onto your string rather then include the Data Item name inside the string. The "Destination Range" parameter should have been:

"A1:BJ" & [Adhocs number of rows]

------------------------------
Micheal Charron
Senior Manager
RBC
America/Toronto
------------------------------

RE: How do I write the expression for Cell reference if the end cell is variable

Fran.Woodcock — Fri, 12 Jan 2024 10:36:00 GMT

Hi Michael

Of course I did... rookie mistake... I'm still getting the hang of writing expressions

Thanks very much 🙂

Fran

------------------------------
Fran Woodcock
------------------------------