Delete fill active range

[rspalding]

Hi,

I'm trying to add the following code But it errors out. I want it to select whatever is selected. It will always start at B8 to S8 and down from there.

ActiveSheet.SelectRange.Select
Selection.Interior.Color = xlNone


Thanks,

Robert

 

[Joe4]

What exactly is "SelectRange"?
Is it some range you have defined somewhere?
How have you defined it?

 

[rspalding]

The active range is the range that is already selected on the worksheet.

 

[Joe4]

If the range you want to apply it to is already selected, then get rid of that first line of code. Not only is it incorrect, it is also unnecessary.

 

[rspalding]

Perfect.

Thank you!

 

[smozgur]

Perfect.

Thank you!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

 

[Joe4]

You are welcome. Glad I was able to help!