First empty colun

ı have an excel sheet a1 ,b1,c1 columns not empty ı want to look up range d1 column name ı want to how can ı get first empty column name for example like this “d1”

Hi @sedayngl_sedayngl33

To get first empty column name use this

Chr(65+dt1.Columns.Count).ToString.ToLower()+“1”
Where dt1 is the datatable

Regards

Nived N :robot:

thank u ı wanna try this:)

can u show look up range

I didn’t get u

for example a1,b1,c1 is not empty ı want to d1 column that is output should be d1

Hi Seda,

What is the purpose of finding this empty column, you want to delete it or add new values in it?