09-21-2011, 03:16 AM
Hi,
It is solved,I gave 3 for loops according to its sheet.
For intRow = intStartRow to xlWrksht.UsedRange.Rows.Count
Next
For intRow = intStartRow to xlWrksht1.UsedRange.Rows.Count
Next
......
Thank you
Uma
It is solved,I gave 3 for loops according to its sheet.
For intRow = intStartRow to xlWrksht.UsedRange.Rows.Count
Next
For intRow = intStartRow to xlWrksht1.UsedRange.Rows.Count
Next
......
Thank you
Uma