Find the last filled column

Hello All,

I was searching for something else at MrExcel.com but found this interesting bit of code. This code will give you the last filled column in a Sheet.

Public Sub find_last_column()
‘Found at MrExcel.com-solution given by Tom Urtis
Dim LC%
LC = Cells.Find(What:=”*”, After:=[A1], SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column
MsgBox LC
End Sub
Related Posts

Parse data with double spaces

Find last filled column

Change the creation date of a workbook

My experiments with sparklines

Auto Filter Cursor Movement

About the Author

A co-author of Data Science for Fundraising, an award winning keynote speaker, Ashutosh R. Nandeshwar is one of the few analytics professionals in the higher education industry who has developed analytical solutions for all stages of the student life cycle (from recruitment to giving). He enjoys speaking about the power of data, as well as ranting about data professionals who chase after “interesting” things. He earned his PhD/MS from West Virginia University and his BEng from Nagpur University, all in industrial engineering. Currently, he is leading the data science, reporting, and prospect development efforts at the University of Southern California.

>