Hi Experts,
I have been receiving alot of help from the Experts in the community and I appreciate everyone’s help! I am still a beginner in using UiPath studio.
For this question, I would like to ask, how can I hold down the shift key.
Firstly, I want to hold down the shift key and press the ‘down’ hotkey to highlight the cell range. However, the number of times I press the ‘down’ key is determined by the number of descriptions I have using ‘While’ activity (Loop).
Below is the script I built.
gulshiyaa
(gulshiyaa )
May 10, 2020, 8:08am
2
Hi @Steven_Kho
In sendhotkey please Indicate the screen
If this’s your solution please mark as solution
Regards,
Gulshiyaa
Hi @gulshiyaa
That’s not the solution, sorry.
@Steven_Kho ,
User select range activity and specify the range(like “A1:A6”}
Hi @MuralidharVankamaddi
The range will differ based on the ‘Description’ variable.
So I cannot pre-define it
gulshiyaa
(gulshiyaa )
May 10, 2020, 8:13am
6
do you want to highlight the cell based on condition?
hi @Steven_Kho ,
I am not sure wether this will work -
you can put only the Shift hotkey before the while loop.
Inside the While Loop - we put only Down key.
–
Mukesh
gulshiyaa
(gulshiyaa )
May 10, 2020, 8:15am
9
Plz Check With this
If you want to change color you can change
1 Like
Is this how the data is Placed in Excel and you want the select . Here I am having till row 13 only. …
If possible can you show how data is placed in excel .
–
Mukesh
My aim is to highlight these “Social Media Campaign…”.
Okay - Is the text at the Beginning Consistent - Social Media ?
Hi, yes.
Currently I am trying the method recommended by @gulshiyaa
Assign activity: ‘Range’ → “A19:” + “A” +(Description+18).ToString
Select Range activity: ‘Range’
this solution managed to work
2 Likes
system
(system)
Closed
May 13, 2020, 8:38am
15
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.