Search:

Type: Posts; User: siddharthsindhwani

Search: Search took 0.00 seconds.

  1. Hi, no scroll area was set but yes, there are a...

    Hi, no scroll area was set but yes, there are a few hidden columns and rows in the sheets.

    Thanks
    Sidd
  2. Hi, The error was encountered on the following...

    Hi,

    The error was encountered on the following line...

    With .Worksheets(i).UsedRange

    no the sheets were not protected..

    Cheers
    Sidd
  3. Hi, The code is much faster than its other...

    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...
  4. Removing unused Cell styles - need an efficient code

    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...
  5. Hi Nishun, I used your SQL statement but it...

    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...
Results 1 to 5 of 5