Finding the next empty cell in a row

[olivetwist]

I am running a macro to import excel files and need help.

I am needing to find code to set a variable "Y" to the column number of the next empty cell in a row.

For example: if row 6 has data from column 3 to 50 but column 32 is blank then set y = 32.

[olivetwist]

I figured it out:

Y = ws.Range("C6").End(xlToRight).Column

I was using xlRight instead of xlToRight which is why it kept erroring out.

[donaldsims]

Thanks for sharing the solution.

[BrynjulfRasm]

Thanks for the useful information