Prev: worksheet skipped in page numbering
Next: Why is the font tab missing from Format Control box?
From: Don Hills Don on 12 Jan 2010 15:29
I am trying to set up some data entry by using the form button, but in trying
to enter data in the middle of the worksheet I get a message saying "the
command could not be completed by using the range specified. Select a single
cell within the range and try the command again". Any ideas or help would be
appreciated!
From: trip_to_tokyo on 12 Jan 2010 15:56
Hi Don.

In EXCEL 2007 I have just set up a small set of data in cells G 17 to I 22.

Three solumn names are:-

Member Name

Date Joined

Amount Paid

I have then filled 5 rows with data beneath those column names.

If I then click in cell G 17 (containing the Member Name field header) and
click on my Form button (set up in the Quick Access Toolbar)

- Form launches corrrectly.

Seems to be working OK for me so do not seem to be able to re-produce the
problem you are having.

If my comments have helped please hit Yes.

Thanks.

"Don Hills" wrote:

> I am trying to set up some data entry by using the form button, but in trying
> to enter data in the middle of the worksheet I get a message saying "the
> command could not be completed by using the range specified. Select a single
> cell within the range and try the command again". Any ideas or help would be
> appreciated!
 | 
Pages: 1
Prev: worksheet skipped in page numbering
Next: Why is the font tab missing from Format Control box?