Hi, no scroll area was set but yes, there are a few hidden columns and rows in the sheets.
Thanks
Sidd
Type: Posts; User: siddharthsindhwani
Hi, no scroll area was set but yes, there are a few hidden columns and rows in the sheets.
Thanks
Sidd
Hi,
The error was encountered on the following line...
With .Worksheets(i).UsedRange
no the sheets were not protected..
Cheers
Sidd
Hi,
The code is much faster than its other predecessors as you have used the Arrays. Many thanks for this.
I believe there is no other way than to loop through each cell on each sheet to...
Dear All,
While working on various models, the users sometimes move sheets or copy formats from different workbooks leading to duplicate or junk cell styles.
Removing the same is a tedious task...
Hi Nishun,
I used your SQL statement but it gives only records which are not repeating. So in the below example we are only left with col2 and col3 values.
I am assuming that count function...