Delete entire row of data in Excel sheets

[Rizana]

I'm working on a simple program that enabled the user to insert and delete data. The user will insert the data via VBE forms and will be saved in an Excel sheet.

The problem is that, I don't know what is the right VB codes to execute the actions?

I tried to use this code, but it doesn't seems to work.

Sheet12.Rows(i).EntireRow.Delete = True

Any ideas?
Thanks in advanced

 

[GlennUK]

Why the "= True" on the end?

 

[sykes]

If your sheet's name is "sheet12", and assuming that your "i" is a declared integer, then:

Sheets("sheet12").Rows(i).EntireRow.Delete

...should work.

If your sheet is the 12th sheet in a series, but called something else, then

Sheets(12).Rows(i).EntireRow.Delete

...should work.

 

[GlennUK]

Hi Sykes,

if the sheet's code name is Sheet12 then

Sheet12.Rows(i).EntireRow.Delete

will work.

 

[sykes]

Hi Glenn

Yes, you got there before me, didn't mean to post over you.
Also thanks for that - I've learnt something else there.

Regards

 

[Rizana]

Thanks a lot

Hello Sykes n GlennUK,

Thank you sooo much for the solution. I'm not familiar with this language and everything seems so hard for me even for an easy problem like this.

Thank you soo much.

Regards,
Rizana

 

[sykes]

It's a pleasure
I'm self-taught, and as you can see from my earlier post, am still learning all the time!!

 

[GlennUK]

My pleasure too. I am also self-taught, and am still learning after many many years of working with Excel and VBA.