ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is there a IsEmptyCell function in VBA? (https://www.excelbanter.com/excel-programming/350936-there-isemptycell-function-vba.html)

WannaBeExceller

Is there a IsEmptyCell function in VBA?
 
I was wondering if the is something within VBA that checks if a cell is empty
or null. I would like to incorporate something like that within the code I am
working on. thanks.

Norman Jones

Is there a IsEmptyCell function in VBA?
 
Hi WannaBe,

Try:

If IsEmpty(Range("A1")) Then

---
Regards,
Norman


"WannaBeExceller" wrote in
message ...
I was wondering if the is something within VBA that checks if a cell is
empty
or null. I would like to incorporate something like that within the code I
am
working on. thanks.




WannaBeExceller

Is there a IsEmptyCell function in VBA?
 
That worked pretty well. Thank you.

"Norman Jones" wrote:

Hi WannaBe,

Try:

If IsEmpty(Range("A1")) Then

---
Regards,
Norman


"WannaBeExceller" wrote in
message ...
I was wondering if the is something within VBA that checks if a cell is
empty
or null. I would like to incorporate something like that within the code I
am
working on. thanks.






All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com