With clear content

[Undo]

Hey

What code should I use for :
with range table1 sheet1 column a
clearcontets for blank cells

Thats all,Thanks

[ikboy]

See if this is what you wanted.

Please Login or Register  to view this content.

[Undo]

@ikboy, No no bro, This clearcontents for all cells in culomn a
I want to clearcontent only for blank cells, yes I mean what I say, clearcontets for blank cells in coulmn a, table1
thanks

[ikboy]

Sorry I do not understand.
Blank cells the means are no any contents, how to clear contents for blank cells.
Please upload a clear example. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information.

[Undo]

yes .. clear content for blank cells in range a sheet1 table1

I need that because I have counta formula.. and sometimes its not working probbly.. only if i clear the content for refrence cells.. no need to expailn more

just give me code that clearcontent for blank cells in that range.. that will solve my problem.. and no need to solve my main problem

thanks

[ikboy]

Assume you say that blank cells content with some non visible characters.

Please Login or Register  to view this content.

[Undo]

Thank you!!