Range.clear failure

Hi, i'm creating an excel front end for an access db and currently the getting data bit is working nicely..

so i was happily coding away until this happened!:

Please Login or Register  to view this content.

and the range.clear failed... this is irratating as if i remove it it will leave aspects on the page and be confusing for both the program and the user :-(

and chance you can point me in the right direction?

thanks!

Jonathan

Failed how? Error, explosion, sudden rain of jelly? If by chance it was an error, what was the error message?

I suppose your intention is to clear the contents of a given cell:

Please Login or Register  to view this content.

I can't think of any error message in this case unless the sheet doesn't exist, the cell is protected or part of an array.

What happens if you try to empty this cell manually ?

(is a querytable connected to this cell ?)

Are you sure the name Sheets("Edit Package") is written correctly ?
Are several workbook open ? In that case you should mention the workbook too:

Please Login or Register  to view this content.

another approach:

Record a macro emptying this cell; compare the recorded macro with you current code.

the code gives me the error, subset out of range!

I bet you got that because you didn't adapt my code (or it would be a rare coincidence that one of the opend workbooks is called 'opened.xls'

I think it's time to put your workbook here and tell us how many workbooks are opened at the same time the macro is running and where you store the macro you are running.