Type into - excel go to cell by variable

studio

#1

Hi,

I try to use Send Hotkey and Type into activities to locate a specific cell in excel by variable with:

  1. Send Hotkey: Ctrl G
  2. Type into: “variable[k(enter)]”

image
Error: Type into ‘client GT’ : Write text failed.

The problem is that in the pop-up Go To window, it does not accept variable. Is there a way to work around it ? Or did I pass the variable in the wrong syntax ?

Many thanks


#2

Hi @Snowman,

Ctrl +G -> its finding the cell location for example “B3”

use Ctrl+F -> to find the word in the excel sheet.

Regards,
Arivu


#3

Hi @arivu96,

Happy to see you in the late Sat night :wink:

Actually I try to go to the cell, eg. D7 with 7 as a variable. But I was stuck in the Go To pop up window.

I tried also “[k(”+variable+")][k(enter)]" , but still doesn’t work.


#4

Hi @Snowman

:laughing:

"D"+variable+ "[k(enter)]"

Regards,
Arivu


#5

It was great !!! Can enjoy my Sunday with this fixed.

Thank you very much, and enjoy your weekend :smile:

Snowman


#6

Hi @Snowman,

:laughing::laughing: enjoy
You are always welcome and enjoy your weekend :smile:

Regards,
Arivu