Why can you not do 'ws1.Rows("B10:C1000").Delete'

Hello,

I am trying to delete an area on a worksheet like this

ws1.Rows("B10:C1000").Delete

How can I achieve this correclty?

I would like to delete the contents of the area between B10 and C1000?

:)
gisvpnAsked:
Who is Participating?
 
SteveConnect With a Mentor Commented:
need Range not Rows and ClearContents not Delete

ws1.range("B10:C1000").clearcontents

Rows is only for entire Rows
Delete will remove the cells.. which can shift stuff about.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.