Hi All, I’ve a requirement to apply auto fit for the merged columns and the text should be visible to read. I’ve multiple excel files with different columns are merged. Robot should read the excel file and find the merged columns and apply auto fit. For example, one excel file D1 to H1 was merge…

Hi All, I found a solution :blush: working fine. Am sharing the script which will help if anyone wants to find a merged cell in the excel file and apply to autofit. Sub FindMergedCells() ' Declare sheet you want to look for merged cells on - in the example it's sheet 1 Dim sheet As Worksheet S…

How to apply auto fit for the merged columns [Excel]

Help Studio

muhammedyuzuak (Muhammed Yuzuak) June 15, 2022, 3:44pm 2

Hi @Shagoul_Hameed,

Have you had a chance to check this link?

Regards,
MY

1 Like

Topic		Replies	Views
How to AutoFit All Columns in Excel Help excel , studio , question , package_management	23	9969	December 26, 2019
Autofit column in a excel sheet Help excel , activities , question	7	4582	November 23, 2019
How to autofit columns in Excel document Help	6	5240	February 13, 2019
How to AutoFit Columns in Excel before copy to Data Tables and create file CSV Studio datatable , excel , question	13	1697	January 15, 2021
BalaReva.Excel.Activities : Autofit Studio	16	2229	January 12, 2021

How to apply auto fit for the merged columns [Excel]

Related topics