Non empty cell

[kcompton]

What is a non-empty cell? How do I eliminate non-empty cells?
Thank you

 

[twinpowr]

Hi,

A cell that has anything in it, including a formula is considered by Excel to be NON empty.

Do you want to delete these cells?

Post some code or explain what it is you are trying to do. to help us see how we can help.

thanks

Ally

 

[kcompton]

Thank you.
I have a program that merges tables - AbleBits.
When I went to merge one table with another, I received a message that my main table contained non-empty cells and that some data may shift as a result after the merge. This did not make any sense to me - why would a non-empty cell cause data to shift?" so I thought I may not be understanding what a non-empty cell was.
I have also posed this issue to AbleBits to find out why finding non-empty cells during a merge would cause data to shift.

 

[twinpowr]

Hi again

try this link, this discusses merging data into a table, you maybe able to modify to your needs

http://www.mrexcel.com/forum/showthread.php?t=515109&highlight=merge+tables+excel

lets us know how you get on.

Ally.

 

[twinpowr]

Found this webpage have a look, it too discusses merging data tables.

http://www.digdb.com/excel_add_ins/join_merge_tables_lists/

Ally

 

[kcompton]

Thank you again.
The DigDB link looks very similar to the AbelBits Merge Tables add-in. I will try out the DigDB add-in and see if I receive the same message/issue with "non-empty cells".

Thank you for you help.