I found this last row statement below which works well. But i want to find a "last column" equivalent using this type of method..........does anyone know?
where fl_output_sht is a user defined data type of "worksheet"![]()
last_row1 = fl_output_sht.Columns(1).Find("*", fl_output_sht.Cells(1, 1), xlValues, xlPart, xlByColumns, xlPrevious, False, False).Row
Bookmarks