How Capture Range of Excel Cells Data Was Copied Into

Help Studio
1

Hi,

I have an automation that goes to a website, does a search, and then copies the results to a blank worksheet in excel. This runs once per week. Each week the amount of entries copied changes. After the data is copied to excel I would like to be able to format the cells but the range of cells changes each time so I am unsure how to do this.

Is there a way to record the cell range that data is copied to so that I can use it in a subsequent format activity? I hope this makes sense.

2

@Kaydo

Welcome to the community

You can give Excel.Sheet("SheetName").FullRangeValue this till get the full filled rage by default

Cheers

3

@Kaydo,

I assume your number of column are fixed. So just get the last row with Find First/Last Data Row activity.

Use this last column and last row to build dynamic range to pass to Format Cells activity

Thanks,
Ashok :slight_smile:

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.