Find the last used column

[Bob Phillips]

I am looking for code that will find the last used column. In other words, the last column (left - to - right) that has a value in it.

You can do it with a worksheet function. This is for row 3

=MAX(IF(3:3<>"",COLUMN(3:3)))

and is an array formula, so commit with Ctrl-Shift-Enter