rajagopal
10-20-2008, 03:20 AM
Hi,
I was using the code given in the KB entry http://vbaexpress.com/kb/getarticle.php?kb_id=578
I'm getting a Run time error' 1004 - Method 'Goto' of object appreciation failed message.
It seems to be an error in the line
Application.Goto Worksheets(1).[A1], True '< Optional
Can you anyone help.. i've given the error screenshot and also the working file as an attachment..
I was using the code given in the KB entry http://vbaexpress.com/kb/getarticle.php?kb_id=578
I'm getting a Run time error' 1004 - Method 'Goto' of object appreciation failed message.
It seems to be an error in the line
Application.Goto Worksheets(1).[A1], True '< Optional
Can you anyone help.. i've given the error screenshot and also the working file as an attachment..