VBA Help

[JoeyGaspard]

Hi all, I have a spreadsheet where I am trying to use VBA to delete all rows if the cell in column B is blank, for some reason it is not working? The code I am using is listed below, any help is greatly appreciated!


'Delete Blank Rows if No Data in cells in Column B
On Error Resume Next
Sheets("GeneralJournal").Select
With Range("B17:B500")
.Value = .Value
.SpecialCells(xlBlanks).EntireRow.Delete
End With
Range("B17").Select

Thanks!

 

[JoeyGaspard]

Sorry It returns nothing, the cell i put the formula in returns blank

I would be glad to send you the spreadsheet if you think that would help?

 

[JoeyGaspard]

Sorry It returns nothing, the cell i put the formula in returns blank

I would be glad to send you the spreadsheet if you think that would help?

 

[Joe4]

Sorry It returns nothing, the cell i put the formula in returns blank

That is not possible. Then LEN function cannot return nothing. It should return a number, like 0.
Do you have some sort of Custom Format being applied to the cell you are placing it in that hides/suppresses the number 0?
What is the format on that cell?

 

[Fluff]

If you put it on a share site such as onedrive, google, dropbox, mark for sharing & post the link to the thread I will take a look at it.

 

[JoeyGaspard]

That is not possible. Then LEN function cannot return nothing. It should return a number, like 0.
Do you have some sort of Custom Format being applied to the cell you are placing it in that hides/suppresses the number 0?
What is the format on that cell?

 

[JoeyGaspard]

If you put it on a share site such as onedrive, google, dropbox, mark for sharing & post the link to the thread I will take a look at it.

AccTrish.xlsm

drive.google.com

 

[Fluff]

That is asking me to sign in, you need to mark the file for sharing & then post the link that it gives you.

 

[JoeyGaspard]

That is asking me to sign in, you need to mark the file for sharing & then post the link that it gives you.

AccTrish.xlsm

drive.google.com

 

[JoeyGaspard]

That is not possible. Then LEN function cannot return nothing. It should return a number, like 0.
Do you have some sort of Custom Format being applied to the cell you are placing it in that hides/suppresses the number 0?
What is the format on that cell?

It was returning a zero, it just wasnt showing in the cell

 

[Joe4]

It was returning a zero, it just wasnt showing in the cell

OK. Thanks for confirming.

Unfortunately, I am unable to download files from my current location (our work computers are "locked down"), but it sounds like Fluff is able to.
Hopefully, he will be able to determine what is going on.