Autofill in Excel using StudioX

Help StudioX
,
1

Hi Automation Masters!

How to use Autofill without filling the cell of hidden rows?
Robot filters the selected column then the robot must fill the data of the selected column in Excel… but the robot fills also the hidden rows…

2

Hi @flashdrive07

Can you try the following?

image
image854×1076 45.4 KB

Input:

image

Output:

image

You can see it is not writing in hidden rows in below Screen shot

image

NewBlankTask5.zip (274.3 KB)

Hope this helps!!

7

Hello @lrtetala ,

is there any other option ? using vba might not work in my actual data