Clear cell contents based on defined name

**SMB** · 01-13-2010, 11:23 AM

Hello,

I'm trying to clear cell contents based on a defined name given to a set of various cells in my worksheet. The cells are not continuous, but since they're given that defined name, I don't think it matters.

The defined name is listed as "CommentsFields".
The worksheet name is listed as "QPRForm_V6"

I found a similar thread, but cannot get it to work with what I'm looking for. I'm relatively new to writing VBA/macros, so I'm not sure what to do.

Any ideas are greatly appreciated!

**sweep** · 01-13-2010, 11:37 AM

I may be missing the point, but won't this

Please Login or Register  to view this content.

do what you want?

**SMB** · 01-13-2010, 12:15 PM

Originally Posted by sweep

I may be missing the point, but won't this

Please Login or Register  to view this content.

do what you want?

I tried your above suggestion w/o the extra "..as seen below..and received a 400 error.

Please Login or Register  to view this content.

Then changed to the below..still received the 400 error.

Please Login or Register  to view this content.

**sweep** · 01-14-2010, 04:18 AM

That's odd. Is the workbook containing the named range active when you run the code?

**SMB** · 01-14-2010, 11:36 AM

Hi again,

I scaled down the worksheet contents, due to work based restrictions, but what is attached should show the issues that I'm having..The workbook that contains the macro, defined name, and the sheet are the same and are active when I try to run it.

The name CommentsFields selects all of the fields (mostly filled with asdf for example comments)

Any suggestions?

**sweep** · 01-14-2010, 11:46 AM

You have merged cells which will have to be unmerged prior to clearing, like this,

Please Login or Register  to view this content.

or if you don't want to unmerge, this will work,

Please Login or Register  to view this content.

**SMB** · 01-14-2010, 12:48 PM

Hi there, Thanks for the options!

They worked..I added to your reputation. I appreciate the help. Thanks again!

Clear cell contents based on defined name

LinkBack

Thread Tools

Rate This Thread

Display

Clear cell contents based on defined name

Re: Clear cell contents based on defined name

Re: Clear cell contents based on defined name

Re: Clear cell contents based on defined name

Re: Clear cell contents based on defined name

Re: Clear cell contents based on defined name

Re: Clear cell contents based on defined name

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions