Clear Content

[Smurfit-Stone]

Hello Board,

I need a macro that will clear the content of multiple range names. I do not want to delete the range names, just clear the content in them. I need to clear a spreadsht daily to enter new data, there are 13 range names, that need to be cleared. Is there a easy way to do this? Thanks in advance.

 

[Boller]

Norie

What's the point of assigning the ranges to an array and then clearing the comtents of the array?

Why not just clear the contents directly?

 

[Smurfit-Stone]

Boller, I'm still getting the error message "Wrong number of arguments or invalid property assignments", in a Compile Error message box. I thought I compiled it, but I must be doing something wrong. Please help.

 

[Norie]

The code I posted isn't doing that - it's storing the names of the ranges in an array

 

[Boller]

Boller, I'm still getting the error message "Wrong number of arguments or invalid property assignments", in a Compile Error message box. I thought I compiled it, but I must be doing something wrong. Please help.

Range("Unit123, Unit122, Unit120, Unit104, Unit125," & _
"Unit128, Unit133, Unit135, Unit140, UnitSlitter, " & _
"UnitWet, UnitDry, UnitPost").ClearContents

 

[Boller]

The code I posted isn't doing that - it's storing the names of the ranges in an array

Why do that?

 

[Norie]

Why not?

 

[Boller]

Why not?

Was merely wondering if you had a reason for doing it that way.
Apparently you don't.

 

[MrKowz]

The problem has been solved in this thread: http://www.mrexcel.com/forum/showthread.php?t=540240

Norie's array idea, I can see, could be very helpful for aesthetic purposes. However, we all have our own programming practices. Some like to store things in an array before using the items, some like to straight up use the items.

 

[Norie]

I actually did it for a few reasons.

One of which was basically because it works.

Another because, and it might be a long shot, the array is reusable.

Oh and I did mention in my last line of the post another reason.

Not sure about aesthetics - doesn't seem particularly artistic of beautiful to me, but then again most code doesn't.