Using the Isblank function for the same cell (Isempty via VBA)

Hi.
I’m trying to do the following action:
If cell(B2) Isblank -> fill “Text” in cell(B2)
Otherwise -> Leave cell(B2) as is

I know functions usually cannot apply input & output for the same cell, but must use a range.
So i’m looking for a VBA code with the Isempty function to make me happy. Any ideas?
Thank!

Thanks for the fast reply!
So as i'm new to VBA, now i'm facing new challenges:
1. it needs to be a loop. I mean to for every cell in column B
2. i'm not sure how to run/apply the code.

Thanks!

Hi !

1. No need to loop in VBA just using the Excel basics …

1&2 : attach at least a sample workbook with the same layout than the original …

Hi!

Not sure i understand #1, but here is clarification:

I got a list of products and column J is Product Type which i cannot leave empty.
So if a cell Jx (J3 for example) is empty, i’d like it to be filled with “Unknown”.
If it isn’t empty, i like to keep it the way it is.

I hope that was good as a sample

Works! Thank you so much! You earned my star and a place in heaven <3

For those who might be interested, here is another one-liner that will also work...

Please Login or Register  to view this content.