A little help .range

**Excel Oregon** · 10-31-2023, 10:16 AM

I am trying to use the following code to clear a data entry form on page Members. I keep getting "object required" error.

Please Login or Register  to view this content.

Any help is appreciated

**Fluff13** · 10-31-2023, 10:36 AM

What exactly is "Members"?

**Excel Oregon** · 10-31-2023, 11:01 AM

Members is a page in my workbook.

**Fluff13** · 10-31-2023, 11:24 AM

What do you mean by a page? Is ti the name of a worksheet as seen on the tab, a codename for a sheet or something else?

**Excel Oregon** · 10-31-2023, 11:27 AM

it is just the name of one of my worksheets.

**Fluff13** · 10-31-2023, 11:28 AM

In that case you need to use

Formula:

Please Login or Register  to view this content.

**Excel Oregon** · 10-31-2023, 11:37 AM

That worked, thanks.

I saw it used exactly as typed from an example I saw online.

**Fluff13** · 10-31-2023, 11:43 AM

Glad to help & thanks for the feedback.

I saw it used exactly as typed from an example I saw online.

They would probably have been using the codename rather than the sheet name.

Re: A little help .range