Navigate through excel sheets in same workbook

excel
activities

#1

Hi all,
I have a excel based tool where in data has to be pasted in 5th and 4th sheet and i need to back to sheet 1 to tap on submit
I tried through hot key ctrl+ pup/pgdwn could not work

Pls help, thanks


#2

Hello there,
it works for me.
any error message?
Do you mind attaching workflow or screenshot.


#3

Does using Select Range work?
You can use a Workbook variable in your Excel Scope,
For example using wb as your variable…
Select Range "A1"
wb.GetSheets(4)
or
wb.GetSheets(3)
then
wb.GetSheets(0) for sheet 1