Below is the one line code i have written to move sheet named ‘Final’ at the end, [image] Getting this error [image] Kindly help if i need to pass something in the Edit arguments tab. Thank you

@Nishant_mantri Try this Sub MoveSheetToEnd() Dim ws As Worksheet Dim activeWorkbook As Workbook ' Set the active workbook Set activeWorkbook = ActiveWorkbook ' Replace "SheetName" with the name of the sheet you want to move Set ws = activeWorkbook.Sheets("SheetName") …

I did go through this… got the vba code from the first link, but not able to understand how to use the same in Invoke VBA code activity…

Hi Sudharshan, Any help on this? thank you

@rodrigo.simao Hi Rodrigo… any help on this?

Hi @Nishant_mantri Have you tried with macro [UiPath Tutorial | Uipath Execute Macro]

Hello @Nishant_mantri , I’m currently trying to figure it out…

@Nishant_mantri try this Sub MoveWorksheet() Worksheets(“final”).Move After:=Worksheets(Worksheets.Count) End Sub refer this [image] How to move particular sheet as the last sheet Activities Sub MoverToFront() ActiveSheet.Move Before: = ActiveWorkbook.Sheets(1) End …

that is just the VBA code to move the sheet to the end, i need to use that in the Invoke code activity in UiPath… not able to do it… I did go through the link which you have posted, there is no solution in that…

@Nishant_mantri You can also use macros, Try like this [image] Here is the script MoveSheet.vb (202 Bytes) Make sure that this option is enabled [image] Regards Sudharsan

im getting this error in the Entry Method parameters property [image]

How to move excel sheet at the end using VBA script/code

Help Studio

lrtetala (Lakshman Reddy) October 10, 2023, 3:34pm 13

Hi @Nishant_mantri

You can try this xaml by using Invoke Code

BlankProcess13.zip (44.1 KB)

Topic		Replies	Views
How to move particular sheet as the last sheet Activities excel , activities , question	3	1473	July 18, 2022
Bala Reva Easy Excel Activity - Move Sheet Studio studio	2	58	November 2, 2025
Adding and renaming excel sheet in a workbook Help	6	5136	September 16, 2019
Vba change to vs code in invoke code activity Activities excel , activities , question	3	1186	November 3, 2021
Get sheets without using excel scope Activities excel	5	1795	October 19, 2020

How to move excel sheet at the end using VBA script/code

Related topics