vba to delete rows in table error

[dshafique]

Hi guys, for one of my spreadsheets i wanted the vba to check if a cell was blank in the first column of my table, and if so to delete it.

this is the code which i usually use

Range("IRA[CIO]")..SpecialCells(xlBlanks).EntireRow.Delete

but when i run it, i get an error saying delete method of range class failed.

any idea what it is and how i can overcome this?

thanks

 

[My Aswer Is This]

edit​

 

[My Aswer Is This]

I see two ..
I think it should only be one.
Range("IRA[CIO]")..SpecialCells(xlBlanks).EntireRow.Delete

 

[dshafique]

sorry about that, my code actually only has 1 dot, but i still get the same error

 

[My Aswer Is This]

Please tell us what your trying to do.
Is IRA a sheet name?

Give specifics.

 

[JackDanIce]

Have you confirmed column IRA[CIO] is completely empty in your table? That error suggests it may not be, hence it can't find any special cells to then delete entire row...

 

[dshafique]

IRA is the name of a table in one of my sheets. there are gaps in the CIO column, which I wanted it to delete. I found a workaround for it,
i just did

Columns("A").[COLOR=#333333]SpecialCells(xlBlanks).EntireRow.Delete[/COLOR]

it did what I needed it to. thanks

 

[JackDanIce]

Does seem unusual your workaround works but the original didn't, the only part you've changed is the range object ...

.. but happy days, glad it's resolved and you found your own answer!