Peter Chan
asked on
Problem to With line
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If Sheet0 is the name of a worksheet, Worksheets(Sheet0) should be Worksheets("Sheet0"). If it's supposed to be the index number of the sheet, first of all the sheets index numbers start at 1, secondly, it should be Worksheets(1).
Good point MacroShadow!
Are you sure your problem is solved?
The code you posted will not work as I wrote in a41940880
The code you posted will not work as I wrote in a41940880