Range.Clear fails when range empty

[always_confused]

Hello. I am making a macro that fills in par of a range. However, the size of the total filled range is variable. I would like to start by clearing a large range before filling a smaller section. However, on the first iteration, the range is totally empty, and I get an error. Is it possible to use Range.Clear on an empty range or do I need to figure out some other way of making sure it's empty? This needs to happen at the beginning of one iteration, not the end of the previous one.

Lets say the larger range is Range("A:A") and I want to use Range("A1:A30"), then the next time Range("A1:A20"). I would like to just start my macro with Range("A:A").Clear, so that regardless of the used rows, they're all gone when I run the macro.

 

[Fluff]

You can use Range.Clear on empty cells not a problem.

 

[always_confused]

You can use Range.Clear on empty cells not a problem.

Oh ok, Fluff, thanks, guess I have a problem somewhere else then

 

[Fluff]

What error do you get & what is your code?

 

[always_confused]

What error do you get & what is your code?

I just got rid of it and it's working fine now. I replaced it with

Sheets("name").Cells.ClearContents

and that works fine. Can't remember what the error was, it's kind of a crazy project so I might just be missing something in one of my Subs but who's to say now

 

[Fluff]

Glad its sorted & thanks for the feedback.