Number of Columns on a Worksheet

[Pacman52]

Hi possibly a stupid question but does anyone know if there is a limit to the number of columns that can be on a worksheet that is written to via a Userform?

Logically I wouldn't think there would be a limit but I'm just double checking before I create and code and worksheet that will have 57 columns (so far!).

Thanks for any responses Paul

 

[Fluff]

There are 16384 columns on a sheet & VBA can write to all of them.

 

[Pacman52]

Thanks so much for the confirmation I thought as much. I only asked as I remembered a very odd coding error coming up on a workbook I did a long time ago.

Thanks again

 

[Fluff]

You're welcome.