sonia123
09-30-2012, 02:04 PM
Hi All
I used the code which is mentioned on
article 151 for Combine All Worksheets into one
while combining worksheets it is giving me Run Time Error 1004: Application defined or object defined error on line:
trg.Cells(65536, 1).End(xlUp).Offset(1).Resize(rng.Rows.Count, rng.Columns.Count).Value = rng.value
Please help me out. Thanks in advance.
I used the code which is mentioned on
article 151 for Combine All Worksheets into one
while combining worksheets it is giving me Run Time Error 1004: Application defined or object defined error on line:
trg.Cells(65536, 1).End(xlUp).Offset(1).Resize(rng.Rows.Count, rng.Columns.Count).Value = rng.value
Please help me out. Thanks in advance.